How to use Conditional Formatting for entering text when a condition is met?

Meena

I am creating Project Plan in Smartsheet.

If % Complete = 100% I want Status column to be updated with text = "Complete".

If % Complete < 100%, I want Status column to be updated with text = "In Progress".

If % Complete = 0% I want Status column to be updated with text = "Not Started".

Kelly Moore

Hey @Meena

Enter this formula in your Status column. You can make this a column formula

=IF([% Complete]@row=1, "Complete", IF([% Complete]@row=0, "Not Started", IF([% Complete]@row<1, "In Progress")))

Does this work for you?

Kelly

Kelly Moore

Hey Meena

I don't know of any way, other than saving a sheet as new, to copy conditional formatting rules from one sheet to another.

Kelly Moore

Hey @Meena

Enter this formula in your Status column. You can make this a column formula

=IF([% Complete]@row=1, "Complete", IF([% Complete]@row=0, "Not Started", IF([% Complete]@row<1, "In Progress")))

Does this work for you?

Kelly

Meena

@Kelly Moore Thank you so much!! That worked like a champ!! Another question 🙂 I am linking 1 Smartsheet to another one, but I am not seeing an option to bring over all the Conditional Formatting rules I created in my original smartsheet? Is there a way?

Kelly Moore

Hey Meena

I don't know of any way, other than saving a sheet as new, to copy conditional formatting rules from one sheet to another.

Meena

Thanks @Kelly Moore for your help.