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?

thank you

Find more posts tagged with

Accepted answers

Paul Newcome

My suggestion would be to use a helper column that converts the selection into a numerical value.

=VALUE([Number Selection Column Name]@row)

Then you can just

=SUM([Helper Column]:[Helper Column])

All comments

Paul Newcome

My suggestion would be to use a helper column that converts the selection into a numerical value.

=VALUE([Number Selection Column Name]@row)

Then you can just

=SUM([Helper Column]:[Helper Column])

Roshni Verappan

Thank you that worked perfectly.

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.