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

Find more posts tagged with

Formulas

Dashboards

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.