If statement

Hello, I have a status column and a %compelete column in my workbook. I would like my %complete column to autopopulate 100%, when the status clumn is changed to "complete"


I am writing the If statement, however the column does not reflect a code, it is listed as text

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!