Sign in to join the conversation:
I would like to count how many of my orders do not have PO number (i.e Po Number cell is blank)
Can you help with the formula to do this
Thanks
Try this formula.
=COUNTIFS([PO Number]:[PO Number], ISBLANK(@cell))
Make sure your column title is PO Number. If it's different update my formula to match.
I would suggest adding in additional criteria for another column that is always populated. That way your formula doesn't include the blank rows at the bottom of the sheet.
If you have a date type column that will always have a date in it regardless of whether or not there is a PO Number, you could use something along the lines of...
=COUNTIFS([PO Number]:[PO Number], ISBLANK(@cell), [Date Column]:[Date Column], ISDATE(@cell))
Hello All, My existing formula (working correctly) inserts text of REORDER NEEDED or OK option , formula below: =IF([Stock Quantity]32 < [Reorder Level]32, "REORDER NEEDED", "OK") I would like to add a third text insert of "ORDERED" when criteria of a checkbox has been checked in the ON ORDER column -or a date ordered…
Hello, Team Our team has encountered an issue while using Smartsheet. We have applied the Hyperlink function in a data management sheet to link the Quote ID to the corresponding sheet. This hyperlink is integrated into the automation workflow of Approval Requests. When a requester initiates the approval flow, the hyperlink…
Hi, I’m using Smartsheet with a Master Sheet(All over Projects Basic Summary) and Individual project sheets that have multiple phases. When I change the Assigned Person in the Master Sheet, I want: •It to update only phases that are Not Started or In Progress •It should not change phases that are Completed Is this…
