I am running SharePoint 2013 Standard Edition. I have a custom list that includes three columns:
- Question type (a choice column with three choices: "Parliamentary question", "Petition" and "Open question")
- Status (a choice column with two choices: "In progress"and "New")
- "No. of Parliamentary questions in progress" (a calculated column which I would like to display the number of questions in progress).
If the question type is "Parliamentary question" AND the status is "In progress," I want the "No. of Parliamentary questions in progress" column to display the number of questions in progress at any given time.
I started with the following formula but am unsure how to end it. Any help would be very much appreciated. Thank you.
=SUM(IF([Question Type]]="Parliamentary question", [Status]="In progress”) ...?