Sign in to join the conversation:
Trying to count the total number of "open" and "Waiting" issues in a another sheet
=COUNTIF({Sheet - RAID Log Range 1} Status:Status, "Open")+COUNTIF (Status:Status, "Waiting")
Hitting a wall, getting an error. Anyone have some guidance?
Hi,
if {Sheet - RAID Log Range 1} represents the column Status you want to count in, your formula should look more like this :
=COUNTIF({Sheet - RAID Log Range 1}, "Open")+COUNTIF ({Sheet - RAID Log Range 1}, "Waiting")
Does this help?
Best Regards,
Paul.
You could also use =COUNTIFS({Sheet - RAID Log Range 1}, "Open", {Sheet - RAID Log Range 1}, "Waiting")
I'm working on 2 Smartsheets right now and am trying to create a formula between the two. My first Smartsheet document is called "Stores in Progress." The 2nd Smartsheet is called "Ready for Service." In my "Stores in Progress" Smartsheet, I have a checkbox column called "Ready for Production." I want to design it so that…
Hello, I am struggling to identify a formula that can read multiple selections in a drop down column, find the corresponding selections and prices on another sheet, and return a total cost. The sheet supports samples that are analytically tested. The user chooses which tests they want to conduct for each sample on the…
I have a sheet with separate data fields to create stacked bar charts in my dashboard (one pictured below). I would like to highlight the month/year with the highest value on the dashboard with sheet summary metrics. I have a sheet summary field (Most Sales in a Month) to calculate the highest value using…
