If statement

Matthew Poorman

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

Andrée Starå

Hi @Matthew Poorman

Can you share the formula?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Matthew Poorman

Hi, here is the formula i am using

'=if([Status]4, "Complete", "100%", "") - but it simply reads as text and not a formula

Andrée Starå

@Matthew Poorman

Try this.

=if([Status]@row="Complete", 1, "")

Did it work?

Matthew Poorman

Sadly, this did not work.

Matthew Poorman

Andrée Starå

@Matthew Poorman

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Matthew Poorman

Done & just shared

Andrée Starå

@Matthew Poorman

Oh, now I see.

It's not working because you're using % Complete in the project settings/dependences.

You can't use formulas in the column then.

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Matthew Poorman

Okay, thankyou.

How do i change that?

Andrée Starå

@Matthew Poorman

Here.

https://help.smartsheet.com/articles/765755-modifying-project-settings

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!