RYG symbols return date in different column
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.
Comments
-
Hi,
If I understand correctly.
Unfortunately, when using the TODAY function, it will update to the current day always.
Do you want both dates to be automatic? Is the Green always chosen before the Yellow?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
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.
-
Lets see if I can explain this slightly better
Green = Input today() into [Date]
Yellow = input today() into [MISC] & leave original date in [Date] (i.e. don't change it)
Red = does nothing
-
Ok.
You can't have a date in the Date manually added and then change it to TODAY if something happens. Would it work if we added another column?
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!