How to count green(or bold) cells only?

Options

Hello,

I`m trying to create formula for counting cells colored in green in same row. In excel I used macro for colorfunction but has no idea how to do it in smartsheet

need smth like =sum ([col1]1:[col10]1) if format is the same as in a special cell

Thanks!

Answers

  • Stefan
    Stefan ✭✭✭✭✭✭
    Options

    Hi @Polina Dmitrieva,

    in Smartsheet there is no formula to access formatting information.

    You may suggest an enhancement request, as this would be a good addition. See the link to the right under "Additional Resources".

    What is the rule you apply to color a cell? Maybe we could find another way to count this cells.

    Greetings

    Stefan

    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!