# Issues with Nesting formula for RYG

Options

Hello community,

I simply want to change the status of a RYG-ball by comparing two timestamps.

If Timestamp< Sift start Time than the ball should be Green

If Timestamp> Shift start Time than the ball should be Red

(I would like to incorporate that if the Timestamp< 15 minutes of Shift start Time than the ball should be Yellow) - if this one is not possible it is ok.

When building the formula, this worked as an intermediate result

=IF(Timestamp@row < [Shift Start Time]@row = 1, "Green")

=IF(Timestamp@row<[Shift Start Time]@row = 1), "Green", IF(Timestamp@row>Shift Start Time]@row = 0), "Red", "Yellow"))

I know this is a basic formula, but I can't figure out what I am doing wrong. Can someone please help me?

Thank you,

Ginny

• ✭✭✭✭✭✭
Options

I think if you remove the parenthesis after the "= 1" portion of your if statements, you should be good to go. This should be the corrected formula.. please try and let me know.

=IF(Timestamp@row<[Shift Start Time]@row = 1, "Green", IF(Timestamp@row>Shift Start Time]@row = 0, "Red", "Yellow"))

• Options

I did what you recommended, but it did not work. I'm still getting the same error.

=IF(Timestamp@row<[Shift Start Time]@row = 1, "Green", IF(Timestamp@row>Shift Start Time]@row = 0, "Red", "Yellow"))

• ✭✭✭✭✭✭
Options

I hope you're well and safe!

That formula doesn't look correct. You're also missing a square bracket.

What do you want the formula to do?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• Options

I want the RYG to change automatically.

I simply want to change the status of a RYG-ball by comparing two timestamps. ( extracted the time from the Creadted Timestamp). I really want to use some minutes in the formula, but not sure how to do that.

If Timestamp is at least 15 minutes before Shift start Time then the ball should be Green

If Timestamp is after Shift start Time then the ball should be Red

If Timestam is less than 15 minutes but before shift time then the ball should be Yellow

I have been changing it manually.

• Options

@Andrée Starå were you able to find a solution for me from what I posted above? Any help would be appeciated!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!