2 Formula in One Cell
Options
M13HSE
✭✭
Hi, I'm stuck, I have a basic formula to count resolved encounters daily, but I need to be able to show 0 in a column if the End of Day Numbers column is also 0.
Answers

Hi @M13HSE ,
You can use a nested IF formula to achieve this. I am not sure of where you're picking your resolved numbers from, however, here's a sample formula you can use. The formula will fetch resolved encounters if the end of day numbers is not equal to 0. If it is equal to 0, then 0 is taken as the value.
=IF([End of Day Numbers]@row<>0, COUNT([Resolved Encounters]), [End of Day Numbers]@row)
Thanks,
Aravind GP Principal Consultant
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!