RYG symbols return date in different column

CowGuy27
CowGuy27
edited 12/09/19 in Formulas and Functions

Okay so I'm almost done with my project but I ran into a snag and needed some advice. Basically what I'm trying to do is that when I pick the Green symbol todays date is input into the date column, Yellow = todays date in MISC column and leaves the previous date in the Date column. I've programmed for the green but every time I choose yellow it erases the previous date in the Date column. Is there a way to do this? Thanks in advance for your help with this. 

Untitled1.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!