Count the number of requests submited
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?
Help Article Resources
Check out the Formula Handbook template!