# 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"?

• Are you using the Dependency settings? If so, formulas cannot be used in the columns referenced by the dependencies.

• 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!