Skip to main content
Solved

How To Count Comma Separated Values In A Single Cell

  • August 9, 2020
  • 2 replies
  • 74 views
E
  • Ebba
  • Inspiring
  • 6 replies

Hi there
I have created a table for a client who needs to record the dates visits are made to a site. We note the dates in one cell, separated by commas. We would like to use this data to view the total number of visits. Is there are way to count comma separated values in Airtable?
Thank you!

Best answer by Ebba

Thank you so much for this, Gwynn. It worked perfectly! I really appreciate your support :slightly_smiling_face:

    2 replies

    G
    • gwynn_kruger
    • Participating Frequently
    • 32 replies
    • August 9, 2020

    One way may be to make the dates a multi-select field type:

    The formula for Visit Count is then:
    IF({Visit Dates},LEN({Visit Dates})-LEN(SUBSTITUTE({Visit Dates},",",""))+1)

    E
    • Ebba
    • Author
    • Inspiring
    • 6 replies
    • Answer
    • August 23, 2020

    Thank you so much for this, Gwynn. It worked perfectly! I really appreciate your support :slightly_smiling_face:


    Terms & ConditionsAccessibility statement