How To Count Comma Separated Values In A Single Cell

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!

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

image

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

3 Likes

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

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.