Multiple Formula/Cell question


Hello again,

I have used the following formula and it gives me part of what I am looking for. Is it possible to add to it to subtract the value from another cell (also obtained by a formula)?

=COUNTIFS({RBI CAPA Tracker Year}, Year@row, {RBI CAPA Tracker Dept}, [Primary Column]@row, {RBI CAPA Tracker On Time}, [Column6]$1)

The "On Time" number is technically correct as they are not closed, but I need "On Time Closed" not just all "On Time". I was hoping to be able to add to the formula to be able to subtract the value from the "Work in Progress" column but haven't been able to get anything to work.

Is there a way to do this?

Thank you!


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!