Using Multiple Checkboxes to determine and auto-update % Complete
I have some tasks for an implementation Smartsheet that require different steps. I would like the % Complete column to auto update to 33%, 67% or 100% based on the boxes checked. Obviously if the final box is check it would be the 100% and ignore the 2 boxes that came before it. I attached a screen shot with the formula I attempted but it does not work. Any ideas? Also not sure if the true result should be 33 or .33 if the entire column is set up in % format.
Answers
-
It looks like you are missing an opening parenthesis after your third IF. Once you add that, the values to output should be in decimal format without quotes.
1
.67
.33
0
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!
-
Thank you! I made those changes but it still has the #UNPARSEABLE Error. The exact formula is below. The #BLOCKED in the 'At Risk?' column shouldn't be an issue. It is set to flag if the date is after TODAY and the % is not 1.
=if([Reviewed/Completed]40 = 1,1, if([Data Received/Time Scheduled]40 = 1, .67, if([Sent/Discussed/Requested]40 = 1, .33, 0)))
-
@Lizzie Armstrong My apologies for the delay. I am not sure how the notification for your response got so buried in my emails. Were you able to get this working?
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 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
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!