How to count green(or bold) cells only?



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



  • Stefan
    Stefan ✭✭✭✭✭✭

    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.



    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!