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

  • AravindGP
    AravindGP ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!