How to create a formula
10/30/20
Hi,
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
Frances
Best Answers
-
@Frances Lewis You are going to need to make sure you are creating your cross sheet references properly. When you added the new {Date Column} range, did you just type it in as is or did you click on the link in the help box to reference another sheet?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
That was it. It works!
Answers
-
Are you able to provide a screenshot of the expected result please?
I can see what you want to do but not how you want to display it.
Thanks
Purnima
Purnima Gore
Cierr Limited
Your Time is Important, you want to Stay on Track, We can help you use the Right Tools
-
Hi @Purnima Gore
I don't have a screen shot of the expected outcome. What I want to display is the total of IHCA response for each month.
The formula solution that was given to me (see below), output an an #INVALID REF error when I added the function to give me a total for the month
Thx
Frances
-
@Frances Lewis You are going to need to make sure you are creating your cross sheet references properly. When you added the new {Date Column} range, did you just type it in as is or did you click on the link in the help box to reference another sheet?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
That was it. It works!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!