Sign in to join the conversation:
Good evening:
I am trying to add an OR to the formula below:
=COUNTIFS(Priority:Priority, ="P1", Status:Status, ="Potential")
Potential or Active
Thanks for your help in advance!
Hi
Why don't you use countif and count the factors separately?
Just an idea...
=COUNTIFS(Priority:Priority, ="P1", Status:Status, OR(@cell = "Potential", @cell = "Active"))
You use the OR function in the Criteria section and use @cell references to make them logical statements for the OR.
The same can be done with AND statements which is especially useful when looking at date ranges.
Is there a trick to creating a column of unique values for each row that will not change after it is created? I cannot use Auto-ID because the row then gets copied to another sheet that utilizes Auto-ID and Smartsheet limits that. I'm stuck and ChatGPT keeps making recommendations that don't work.
I have a sheet that has all of our orders on it. I have other sheets "Gantt" for each machine. I want each machine sheet to auto populate every order that is assigned to it, when an order gets assigned to the machine. I don't want to set an automation to copy the row from the orders sheet to the machine sheet because I…
Hi Community Facing a problem many others have posted about, but haven't seen a solution yet and wondered if it had been solved. I want to be able to add a row on a resource sheet for each project resource once a project has been set to 'X' on a Projects sheet. I have tried through automations but the daisy-chain limit…
