Formula Issue: Non-'Complete' Statuses Turning Blank in Column Formula
Answers
-
Hi,
Whilst it does work for done=1 →status=complete. It does nullify all other selected other than complete (they turn blank).
So If I try to change formula to column formula, any cell that is Not blank but Ïn progress", "Not started" and "On hold" and also not "Complete" will turn blank.
So I tried automating but that didnt work, somehow it just turns all status into complete!
Thoughts?
Continuous Improvement Facilitator in HVAC industry || Timezone CES
-
Hi @MPath! When you ran the automation, did you run it by run going to "run automation" and "Trigger workflow on the entire sheet"?
-
yes. I now tried it on a row and everythings is fine. Also tested it in actual scenario and works fine, though it looked like it didn't there was a huge amount of lag on automations yesterday(GMT +1 here). Thanks :)
Continuous Improvement Facilitator in HVAC industry || Timezone CES
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!