2 Formula in One Cell
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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!