My team is using Smartsheet to track interactions with our customers on Facebook. To keep a record of the interactions, we're using a form to populate a sheet with the data (time, date, sentiment, that sort of thing).
I'd like to find a way to automate one of the questions in the form - how many times we've interacted with that customer to date.
Basically, is it possible to use a nested IF formula in a "no. of interactions" column to check for matches in a "name" column and return a number based on how many matches it finds?