Restrictions on "Clear Cells" automation?
I want to set up a rule to have a cell contents cleared when the completed date is filled in another cell. I have used similar automation in the past, but when I try this time is does not give me the column of the cell I want to clear as an option to choose when setting up the rule. Are there restrictions on the cell type or properties for this automation?
In this case, I want the "Days Until Due" column to clear once the "Completed Date" column is not blank
Is it because of the formula in the "Days Until Due" column? Or is there some other very simple explanation that I am missing. I also tried the "change Cells" automation to have it change the Days Until Due to 0 but that didn't work either.
I can present the data in a report and have it ignore the "Days until Due" if "Completed Date" is not blank, but I was hoping to do it in the original Gantt
Best Answer
-
It is because you have a column formula in that column. You will need to adjust the formula instead. My usual is just adding an IF statement to the beginning of the existing formula to say to run the existing formula only if the other cell is blank.
=existing_formula
changes to
=IF([Column Name]@row = "", existing_formula)
Answers
-
@Eric Hall which formula and workflows you use now?
If my comment helps you, I appreciate a 💡
Kind regards
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
-
The formula in the "Days Until Due" columns is
-
@Eric Hall did you try to use a if formula ?
If my comment helps you, I appreciate a 💡
Kind regards
Event: Strategies for Successful Adaption
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
https://www.eventbrite.de/e/driving-change-with-smartsheet-strategies-for-successful-adoption-tickets-1047813557557?utm-campaign=social&utm-content=attendeeshare&utm-medium=discovery&utm-term=listing&utm-source=cp&aff=ebdsshcopyurlWe offer Licenses - Training - Solution Engineering
🔴Certified Smartsheet Partner _______________________________________________
💯 SCALEABLE Solutions Engineered by Lighthouse Consultings
We Don’t Just Implement Smartsheet; We Revolutionize How You Manage, Plan, And Execute.
-
It is because you have a column formula in that column. You will need to adjust the formula instead. My usual is just adding an IF statement to the beginning of the existing formula to say to run the existing formula only if the other cell is blank.
=existing_formula
changes to
=IF([Column Name]@row = "", existing_formula)
-
That's perfect, thanks Paul!
-
Happy to help. 👍️
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives