How do I use a Smartsheet formula to set a row's value in a column "% Complete" to "100%" IF the val
How do I use a Smartsheet formula to set a row's value in a column "% Complete" to "100%" IF the value of the "Status" Column in that row is "Complete"?
Best Answer
-
Are you using the Dependency settings? If so, formulas cannot be used in the columns referenced by the dependencies.
Answers
-
Try this...
=IF(Status@row = "Complete", 1)
-
I need to set the "% Complete" column row to "100%" when the "Status" Column on that row is "Complete".
The logic should be:
If "Status" Column on a row = "Complete"
Then
"% Complete" Column on a row is set to "100%" and this is % formatted field
I am just looking for the correct formula syntax
-
Yes. If your status column is called "Status", then you would put the above formula in the % Complete column.
-
Paul:
My formula is in the "% Complete" column and apparently the formula is not correct.
I have written various formulas before but something must be incorrect with my syntax.
=IF(Status@row = "Complete", 100)
or
=IF(Status@row = "Complete", "100%")
-
Smartsheet calculates percentages as a part of a whole or a portion of 1.
0.00 = 0%
0.25 = 25%
0.50 = 50%
0.75 = 75%
1.00 = 100%
So leaving the output as 1 in a text/number column that has been formatted for percentages should output 100%.
-
'=IF(Status@row = "Complete",1) is my syntax, but the formula remains when I hit the "Tab" key or "Enter" key
-
Are you using the Dependency settings? If so, formulas cannot be used in the columns referenced by the dependencies.
-
Thanks for the information on Dependency setting, which is appreciated.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!