2 Formula in One Cell
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
Reach out for any help on licenses, configuration, or training
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!