Count of free text cells on a dashboard

I have a projects list that is continuously being updated with a field labeled "location".

How can I count the number of instances of each location to place on a dashboard.

It's continuously changing so I cannot just put "countif" function.

Best Answer

Answers

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

    Hi @Pete Cardenas

    Do you know all the possible locations, or can there be new unknown locations added?

    How many locations can there be, do you think?


    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or 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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Absolutely

    The goal is to keep it as a free text. That way locations can be added. This is what makes it difficult. An example below:

    1st floor

    1st floor

    Lab2

    Pavilion

    Lab2

    Lab2


    So in that instance, how can I create a dashboard that should there are 3 projects in the lab, 2 projects in the 1st floor, and one project in the pavilion?


    Thanks for the assistance!

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

    @Pete Cardenas

    Happy to help!

    I saw that Leibel answered already!

    Let me know if I can help with anything else!

    Best,

    Andrée

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!