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.
IF Function

I'm trying to make a progress state based of check mark. For example when I checked on "STATUS 1", then the "PROGRESS" column automatically registered 25%, "STATUS 1 & 2" checked then 50% and so on.
Would anyone know how to do this? Thanks in advance!
Comments
-
Use a formula to calulate and tack on the % instead
Assuming it's the first row:
= ( [Status1]1 + [Status2]1 + [Status3]1 + [Status4]1 ) / 4 * 100 +"%"
-
I dont think Smartsheet will recognize a check as 1. I know 1 = checked 0 = unchecked but for summing, I dont think it sees a check as a numeric number.
Try this instead:
=COUNTIF([Status 1]1:[Status 4]1, 1) / COUNT([Status 1]1:[Status 4]1)
Counts the number of checked boxed and divides it by the total number of checkboxes. Format the cell as a percent.
-
Awoseome! this works!
=COUNTIF([Status 1]1:[Status 4]1, 1) / COUNT([Status 1]1:[Status 4]1)
Thank you so much John!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 146 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 73 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives