Add one more condition to check project status
Hi @Paul Newcome I'm able to calculate projects falls under on time and delay for the month, I would like to check "project status" column and check for "completed",
=COUNTIFS({Month}, Label@row, {OTIF}, [Category 1]$4) im using this formula currently,
Joseph Aloysias| Solutions Lead
vSaaS Global
Book a Meeting
Phone: +91-8148459084
Tags:
Answers
-
You would add another range/criteria set following the same syntax.
-
Thank you @Paul Newcome I got it.
Is there a way we can hide 'Zeros' in the dashboard? would like to show only values.
Joseph Aloysias| Solutions Lead
vSaaS Global
Book a Meeting
Phone: +91-8148459084
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!