Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
% Completed and Task Finished
Comments
-
=if(*select the cell with the checkbox*,1)
-
Guy,
If Dependencies are enabled, you can not have a formula in the % Complete column.
If your completion is binary (either 0% or 100%) and dependencies are disabled, then Luke_TK's formula is OK. If you sometimes want to have a different percentage (ie 49%), then as soon as you enter a value, the formula is gone and won't come back.
To handle situations like this I use Zapier (www.zapier.com) or other automation tool (though Zapier is by far my favored solution) or the API (code development)
Here's a similar example I wrote for Zapier - it takes a check box and enters the completion date. I have another version that allows the user to pick one of the three choices - check box "done", enter the completion date, or mark it 100% complete ... Zapier will fill in the other two. I did this because the PM entered the % Complete and the engineers had the check box .... and both wanted to capture the date.
http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/
I hope this helps.
Craig
Categories
- All Categories
- 14 Welcome to the Community
- 10.6K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives