Column Formula Changes - Change Cell Value
Hi Community,
I have a column that contains a column-formula it has 3 options/ratings: "1-Great", "2-Not Good", "3-Bad",
I set up an Automation that if it changes to 2 or 3 it should check a box in another checkbox column, but this is not working.
I have another Automation that if it changes to a 2 or 3 it alerts soneone, and this is working just fine.
Any ideas?
(The default column settings for the column with the column-formula is a dropdown with above options, and the original column where the VLOOKUP is taking the infomation is also a dropdown with same options.)
Thank you!
Answers
-
Hi @A Rose ,
Hope you are doing Good.
If it's not a issue, could you please share us the Screenshot of automation you have built. Hope that helps us to find better solution and understanding.
Thanks,
Sandhiya P
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!