Count the number of requests submited

Roshni Verappan
Roshni Verappan ✭✭✭✭
edited 06/17/22 in Formulas and Functions

I have a tracker that that is used to capture Recording Requests. there is a column that has Number of recording required and that could be 1 - 3 that can be selected from a drop down. So if a user selects say 2 recordings are required. I would like to have a total column that shows how many recordings are being requested right away.

Formula I tried was :

=COUNTIF([Number of Voice Recordings Req'd]@row, "1"), AND([Number of Voice Recordings Req'd]@row, "2")

I am sure there is a better way to get the total number requested?

thank you

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!