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)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
@Eric Hall which formula and workflows you use now?
If my comment helps you, I appreciate a 💡
Kind regards
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
We 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
Nico | LinkedIn
CEO | Lighthouse Consultings
Lecturer in Business Information Systems | DHBW
________________________________________________________________________________
addvalue@lighthouseconsultings.com
We 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)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
That's perfect, thanks Paul!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives