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
Check out the Formula Handbook template!