RYG Auto Change Formula
Options
I reached out last week but never received a follow-up response. If anyone can assist me, I would appreciate it!
- 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.
Answers
-
Take a look through the below linked thread. There are solutions there that will convert your times into useable numbers. From there it would be a matter of using a nested IF statement to compare the two numbers.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!