Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Auto-increment a new form entry if it matches an existing name
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?
Comments
-
So basically, you would like one cell to give you the amount of interaction with one specific customer (chose by writing his name in another column)?
I used this formula :
=COUNTIF(CHILDREN(), nom1)
If all your document is indented under a parent name, you can do the same. Else, I used this : =COUNTIF(nom:nom, nom1) - 1
Hope it helps,Étienne Desbiens
-
Hi Etienne, that's got it - thanks very much!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives