Checkbox to equal 100% in % complete
Comments

Found my error
The formula should have been
=IF(Completed4 = "true", "100%"

Here is another option.
=IF(Completed@row = 1, 1)
You will need to format your % complete column as a % but then it will load the actual % rather than text.

What if there are multiple status' that equal 100%? what would the formula be for that?
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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!