How to create a formula




I have formulas that tracks the total number of referrals, the referral type, and total successful referrals. I need to add a function my formula to give a breakdown of the total by month and year. I am having difficulty finding the right function to add to my existing formula. The formulas are:

Total number of referrals: =COUNT({Timestamp})

Total number of successful referrals: =COUNTIF({E-mail Outcome}, "Successful")

Total referral type Emer. 24 hour : =COUNTIF({Referral Type}, ="Emergency - 24 hour IHCA response needed")

Can you help?

Thank you


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!