# Formula Not work for only 5 months

✭✭✭✭✭

Hey All,

=COUNTIFS({Request - Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Request - Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Request - Segment}, ="WellMed", {WSS}, ="Accounts Receivable" + COUNTIFS({Complete Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Complete Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Completed Segment}, ="WellMed", {Completed - WSS}, ="Accounts Receivable"))

I'm working on creating a formula that will look at the Month and Year and then count how many instances the WellMed Segment is in a field and the Sub-Segment is accounts recievable.

Basically one sheet is opened and one sheet is completed. For some reason this formula is only not working on Feb-June. Any guesses?

I know the year column isn't in this view but it say 2023 for all 12 Months.

Thanks!

• ✭✭✭✭✭✭
edited 06/07/23 Answer ✓

It helps me to break out the formula:

You do not need the "=" in {Request - Segment}, ="WellMed",

I'm not sure what you are trying to do with attempting to add "Accounts Receivable" to the result of a nested COUNTIF at the end. Is this a mistake?

• ✭✭✭✭✭

=COUNTIFS({Request - Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Request - Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Request - Segment}, "WellMed", {WSS}, "Accounts Receivable") + COUNTIFS({Complete Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Complete Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Completed Segment}, "WellMed", {Completed - WSS}, "Accounts Receivable")

All Fixed! :)

Thanks!

• ✭✭✭✭✭✭
edited 06/07/23 Answer ✓

It helps me to break out the formula:

You do not need the "=" in {Request - Segment}, ="WellMed",

I'm not sure what you are trying to do with attempting to add "Accounts Receivable" to the result of a nested COUNTIF at the end. Is this a mistake?

• ✭✭✭✭✭

=COUNTIFS({Request - Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Request - Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Request - Segment}, "WellMed", {WSS}, "Accounts Receivable") + COUNTIFS({Complete Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Complete Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Completed Segment}, "WellMed", {Completed - WSS}, "Accounts Receivable")

All Fixed! :)

Thanks!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!