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

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.