Formula to Identify Number of Forms Submitted by Individual Offices

moore_r

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

Matt Johnson

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

moore_r

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

moore_r

This is the method I tried for CountIf that was also #UNPARSEABLE.