RYG symbols return date in different column

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. 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!