Posting/Including data from another cell.
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))
Comments
-
Close. Give this a try...
=IF[Last Poll Time]1 <> [Last Seen]1, "Rebooting or Failed to return. Last seen at " + [Last Seen]1)
-
Thank you for the effort. But it didn't work. The screen shot shows the whats in red working. I am wanting to place the Last Seen time in the comments.
-
That is because you have included two extra parenthesis out of place along with an extra equals out of place.
instead of ...
=(IF[Last Poll Time]1
you should have
=IF([Last Poll Time]1
.
instead of
[Last Seen 1]) = "Rebooting
you should have
[Last Seen]1, "Rebooting
.
instead of
+ ([Last Seen]1)
you should have
+ [Last Seen]1)
.
Try retyping the formula EXACTLY as below, and let me know how that works...
=IF([Last Poll Time]1 <> [Last Seen]1, "Rebooting or Failed to return. Last seen at " + [Last Seen]1)
.
NOTE: In my previous post, there was a parenthesis missing after the IF. That mistake has been corrected in the formula here.
-
Solved! And a Big Thank you!
-
Help Article Resources
Categories
Check out the Formula Handbook template!
