RYG Auto Change Formula

Ginny Shoemaker
edited 06/17/21 in Formulas and Functions

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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!