Count the number of requests submited

Options
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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!