Workflow automation? Conditional action?
Comments
-
It depends how you have your percentage cells set up. I use this for mine;
=COUNTIF([Column]2:[Column]6, "Yes") / COUNT([Column]2:[Column]6)
and format as percentage.
Dr. St Nicholas Burrus DHA, PMP
I build Smartsheets for the US Government, State Government, and about a dozen of the US Fortune 100s.
-
The % Complete column would use
=IF(Done@row = 1, 1)
and the Status column would be
=IF(Done@row = 1, "Completed")
.
Do the % Complete and/or Status column also use manual entry? If so, this will not work. You will need to either use all manual entry or automate everything. Once a manual entry is made, it will override and delete any existing formulas in that cell.
-
Ok. That worked. Thanks! Now the issue I am seeing is who to apply those formulas to an entire column. I'm trying to modify a template that has rows with subtasks. Is that going to be a problem?
-
No. You can put those formulas in the first row and dragfill down. If you are trying to use summary formulas for parent rows, we will need to tweak a few things though.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives