How to count green(or bold) cells only?

09/16/20
Answered - Pending Review

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

  • StefanStefan ✭✭✭

    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.

Sign In or Register to comment.