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 (outofstate 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!