Issues with Nesting formula for RYG

Ginny Shoemaker

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")

but adding an additional condition ended up with UNPARSABLE:

=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

Darren Mullen

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"))

Ginny Shoemaker

@Darren M

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"))

Andrée Starå

Hi @Ginny Shoemaker

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!

Ginny Shoemaker

@Andrée Starå

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.

Ginny Shoemaker

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