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 have a sheet that tracks census of sheltered animals and I want to display that census cell in another sheet that matches the room number. I had a formula that pulled that but another admin had accidentally deleted some columns/formulas. In short, I want the data from the census cell to be pulled into another sheet with…
Here is my formula: =IF(OR(ISBLANK([% complete]@row ), [% complete]@row = 0), "not started", IF(AND([% complete]@row > 0, [% complete]@row < 99), "in progress", IF([% complete]@row = 100, "Complete", ""))) Everything works well, until the project is 100%; formula continues to return "in progress" rather than "complete". I…
I need a formula that returns a specific web link to the cell at the row of my helper column ("Edit/Add Event") if my "start date" and "activity name" are NOT blank. Ideally, I'd also like the link to present as text: "Open Dynamic View". Appreciate any help!
