Formula to Identify Number of Forms Submitted by Individual Offices
Hello,
I am working on building a dashboard to display global and individual data regarding different requests (out-of-state travel requests, official functions, etc.) across seven offices. I would like to eventually calculate the monetary value of each of these requests, labeled as 'Amount' on the reference sheet.
I am currently stuck identifying a formula that would calculate the total number of individual office requests within the whole. I started by calculating the total number of 'Form Type" requests from my reference sheet (success). I then tried to refine the data by individual 'Office' (e.g. "PWR") and my formula is #UNPARSEABLE
Any help to find success would be appreciated,
Rachel
Answers
-
Hi @moore_r
Would a COUNTIF formula not work for the number of requests, a SUMIF for the amount? I think AND in your formula is throwing me off. I must be missing something.
Thanks,
Matt
-
Hello Matt,
I tried to do both CountIF and SumIF, but also received the #UNPARSEABLE message. I have to assume that it is something incorrect with the rest of the equation. I tried to look through the new Smartsheet formula template, but am not formula savvy enough to know where I am going wrong.
I appreciate the help,
Rachel -
This is the method I tried for CountIf that was also #UNPARSEABLE.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!