How do I use a Smartsheet formula to set a row's value in a column "% Complete" to "100%" IF the val

William Kennedy

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

Paul Newcome

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

Paul Newcome

Try this...

=IF(Status@row = "Complete", 1)

William Kennedy

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

Paul Newcome

Yes. If your status column is called "Status", then you would put the above formula in the % Complete column.

William Kennedy

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%")

Paul Newcome

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%.

William Kennedy

'=IF(Status@row = "Complete",1) is my syntax, but the formula remains when I hit the "Tab" key or "Enter" key

Paul Newcome

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

William Kennedy

Thanks for the information on Dependency setting, which is appreciated.

Paul Newcome

Happy to help. 👍️