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)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Solved! And a Big Thank you!
-
Happy to help.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!