Distinct Count of 4th Field Added to Formula Pulling 3 Fields

I need a distinct count of a fourth field added to this formula which is a combination of pulling three fields:

=COUNTIFS([Price Sheet Deadline]:[Price Sheet Deadline], IFERROR(MONTH(@cell), 0) = 7, [Round #3 Price Sheet Status]:[Round #3 Price Sheet Status], "Billing Approved", [Account has Updated Renewal Added to SY21-22 TL]:[Account has Updated Renewal Added to SY21-22 TL], 1)

With the three three fields being: Price Sheet Deadline (by month), Price Sheet Status, and if account was renewed=yes.

And I want to add a distinct count of a fourth field called Price Sheets. How would I fit this into the above formula? I tried this but it didn't work:

=COUNTIFS(DISTINCT(COLLECT([Price Sheet]:[Price Sheet},[Price Sheet Deadline]:[Price Sheet Deadline], IFERROR(MONTH(@cell), 0) = 7, [Round #3 Price Sheet Status]:[Round #3 Price Sheet Status], "Billing Approved", [Account has Updated Renewal Added to SY21-22 TL]:[Account has Updated Renewal Added to SY21-22 TL], 1))

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!