Use Conditional formatting to mark cells that contain formulas

Use Conditional formatting to mark cells that contain formulas

Good Afternoon Smartsheet wizards,

While I am relatively new to Smartsheet and have purchased some of the learning, the Conditional Formatting is entertaining. I'd like to prove that certain cells have formulas, or not.

Thank you in advance for your help.

Cheers,

Bill

Answers

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Bill,

    You’d have to use so-called helper columns for there isn’t a way in Conditional Formatting to check if it’s a formula or not.

    Would that work?

    I hope that helps!

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help 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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

  • What do you put in the helper column to indicate a formula?

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    The helper column(s) would have to be manual entry to designate that there is a formula. There are a few different ways you could set it up though. One option would be to enter the column name(s) in the helper column of those that have formulas in them. Then you would base your conditional formatting rule(s) on what text is contained in the helper column rows.

  • That's a good option. I was hoping the helper column could also help me identify when someone accidentally erases a formula which happens too often around here. I don't see any functions like ISFORMULA (Excel has this), though.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Unfortunately there is not an ISFORMULA function, but that is definitely a great idea. Feel free to Submit a Product Enhancement Request when you are able.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @Lisa

    I saw that Paul answered already!

    Let me know if I can help with anything else!

    Best, 

    Andrée 

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.