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

Carrie Tortorella

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))

Leibel S

@Carrie Tortorella

=COUNT(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)))

Leibel S

@Carrie Tortorella

do you have a column [price sheet] in your sheet?

Bassam Khalil

Hi @Carrie Tortorella 

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Leibel S

@Carrie Tortorella

=COUNT(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)))

Leibel S

https://community.smartsheet.com/discussion/comment/297061#Comment_297061

See below I added an @cell reference. Should fix it.

=COUNT(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], @cell = "Billing Approved", [Account has Updated Renewal Added to SY21-22 TL]:[Account has Updated Renewal Added to SY21-22 TL], 1)))

Carrie Tortorella

Hi @Leibel S this formula was also unparseable. It appears the same as the first one pasted too. Are you sure it was changed?

Leibel S

@Carrie Tortorella

do you have a column [price sheet] in your sheet?

Carrie Tortorella

@Leibel S Please forgive me I edited and it worked. Thank you so much!