# How can I get the cell to remain blank instead of returning a 0?

✭✭✭✭

Hello Community,

I'm hoping someone can please advise - how I would adjust my formula to leave the cell blank if the result is 0?

=COUNTIFS({DC UPS Progress}, "Unscheduled", {Core OpCo}, "NSP", {DC UPS Year}, "2022", {DC UPS Scope?}, 1)

• ✭✭✭✭✭✭

Hi @PKane

I hope you're well and safe!

You'd add an IF before the countifs that checks if it's zero, and if it is, it should be blank.

Make sense?

Did that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭

I tried this - but it apparently is not correct :(

=IF(COUNTIFS({DC UPS Progress}, "Unscheduled", {Core OpCo}, "NSP", {DC UPS Year}, "2023", {DC UPS Scope?}, 1)= 0, "-")

Any suggestions?

• Employee

Hi @PKane

You'll need to repeat the formula: once for the IF statement if it's 0, and once again if the result is not 0. Try this:

=IF(COUNTIFS({DC UPS Progress}, "Unscheduled", {Core OpCo}, "NSP", {DC UPS Year}, "2022", {DC UPS Scope?}, 1) = 0, "", COUNTIFS({DC UPS Progress}, "Unscheduled", {Core OpCo}, "NSP", {DC UPS Year}, "2022", {DC UPS Scope?}, 1))

Cheers,

Genevieve

October 8 - 10, Seattle, WA | Register now

• ✭✭✭✭

@Genevieve P. - not only did it work perfectly, but since I am pretty new to formulas, your explanation helped me learn/understand the rationale also - so I cannot thank you enough!

• Employee

I'm glad I could help! 🙂