Zero Formula

Paul Newcome · 08/19/21

@Naina Dave Happy to help. 👍️

BenG0706 · 11/04/21

Was trying this on my sheet. Any thoughts on why I am getting invalid operation for the below?

=IF(=SUM([Date of Early Case Assessment]@row - [Date of Assignment]@row) = 0, "", =SUM([Date of Assignment]@row - [Date of Early Case Assessment]@row))

Andrée Starå · 11/04/21

Hi @BenG0706

I hope you're well and safe!

Try something like this.

=IF(SUM([Date of Early Case Assessment]@row - [Date of Assignment]@row) = 0, "", 
SUM([Date of Assignment]@row - [Date of Early Case Assessment]@row))

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

BenG0706 · 11/04/21

That did it (had to switch the order of the if false portion though). Was the only issue the the equal sign before the sum? Thanks!

Cesar_Rodriguez · 08/28/24

https://community.smartsheet.com/discussion/comment/244848#Comment_244848

Hello Paul, this If formula does work, the issues is that it is hiding all the values in the specific cell, is there a way to just hide the zeros?

Paul Newcome · 08/28/24

@Cesar_Rodriguez

=IF(SUM({Open Positions - Per Employee Group Range 6}, {Open Positions - Per Employee Group Range 7}, {Open Positions - Per Employee Group Range 8}, {Open Positions - Per Employee Group Range 9}, {Open Positions - Per Employee Group Range 10}, {Open Positions - Per Employee Group (SG&A Range 2}) <> 0, SUM({Open Positions - Per Employee Group Range 6}, {Open Positions - Per Employee Group Range 7}, {Open Positions - Per Employee Group Range 8}, {Open Positions - Per Employee Group Range 9}, {Open Positions - Per Employee Group Range 10}, {Open Positions - Per Employee Group (SG&A Range 2}))

Andrée Starå · 08/28/24

https://community.smartsheet.com/discussion/comment/310049#Comment_310049

Excellent!

Happy to help!

Better late than never! (I missed your answer)

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Cesar_Rodriguez · 08/28/24

https://community.smartsheet.com/discussion/comment/451438#Comment_451438

It does work! it is a huge formula but it works. Thank you so much.

Paul Newcome · 08/29/24

@Cesar_Rodriguez Happy to help. 👍️

Zero Formula

Answers

Help Article Resources

Categories