Posting/Including data from another cell.

ed.jaro
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))

 

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    edited 02/27/19

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • ed.jaro
    ed.jaro ✭✭✭

    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.

    SSexample.PNG

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • ed.jaro
    ed.jaro ✭✭✭

    Solved! And a Big Thank you! smiley

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    Happy to help. yes

    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!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!