Issues with Nesting formula for RYG
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
Answers
-
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"))
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
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"))
-
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.
-
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.
-
@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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!