Excel to Return timestamp from another cell

[mlathem1998]

How can I get this to return the timestamp that's in another cell? Where is has scan time, I need that to come from the scan list sheet.

This is where the timestamp is originating from. I need to have this copied to my list instead of saying "No".

Lastly:

I need any employees who have scanned and display the timestamp to show on this roster.

Basically I just need all my info to copy to this only if they have shown to have a timestamp. This will be my electronic roster with the class info for future records after the employee attend the class. I only want it to display everyone who scanned in the list above.

Sorry, I know I asked a lot, but I appreciate any help.

 

[mlathem1998]

Yes but what is the name of the table on the Employee List Badge sheet?

It doesn't have a table name, just a sheet name. Other than that I really don't know what you're asking for.

 

[mlathem1998]

Yes but what is the name of the table on the Employee List Badge sheet?

There isn't a table name that I am aware of, only a sheet name. Unless this is what you are referring to.

 

[Fluff]

That is exactly what I was referring to.
Try

=FILTER(Table_OnPremises3,Table_OnPremises3[Scan Time]<>"")

 

[mlathem1998]

That is exactly what I was referring to.
Try

=FILTER(Table_OnPremises3,Table_OnPremises3[Scan Time]<>"")

That unfortunately didn't work.

 

[Fluff]

Delete everything from the other cells.

 

[mlathem1998]

Delete everything from the other cells.

Everything else in the other cells is empty now.

 

[Fluff]

Is that in a structured table?
If so convert it to a range, that type f formula does not work in a table.

 

[mlathem1998]

Is that in a structured table?
If so convert it to a range, that type f formula does not work in a table.

I think that is what I was trying to say before is that it really isn't a table. At one time it was linking to an OnPremise excel file, but since then I no long have need for that and just keeping things local. Not sure how that needs to change to a range.

 

[Fluff]

It is a Table, as is the data you are pulling from. You will need to convert the output table into a range.
Select the cell with the formula & then select the "Table design" tab & "Convert to range"

 

[mlathem1998]

It is a Table, as is the data you are pulling from. You will need to convert the output table into a range.
Select the cell with the formula & then select the "Table design" tab & "Convert to range"

Well, that ended up being adverse to my file. It completely removed all my scanning and timestamp functionality when I did that.