if formula .

Options
Tadiwa
Tadiwa ✭✭✭
edited 07/19/23 in Formulas and Functions

I have three columns, I want to get the count if the week is 8, the year is 2023 and the country is US. if that condition is not met I want it to return nothing and have the cell empty.

Can anyone help

=COUNTIFS({Submit FY}, "2023", {week}, [Primary Column]@row, {Country}, "US"))

The formula initially looked like that but it returned zero when condition wasnt met. Now I want it to return nothing


@Paul Newcome

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!