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,


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!