Posting/Including data from another cell.

ed.jaro ✭✭
edited 12/09/19 in Formulas and Functions

Within my sheet I have two columns that contain time (hh:mm:ss). In the third cell I am comparing the two columns. If they do not match a statement is posted in a cell stating something is wrong. What I would like to add to the statement is the value from one of the cells containing the time. 

This works, with no added data: =IF([Last Poll Time]1 <> [Last Seen]1, = "Rebooting or Failed to return.")

This doesn't work, but gives a better idea of what I am trying to achieve: =IF([Last Poll Time]1 <> [Last Seen]1, = "Rebooting or Failed to return. Last seen at:" = ([Last Seen]1))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!