SUMIF #NOMATCH Error

Chloe Rose · 2020-08-23 00:00:34

Hi, I'm running into issues when trying to use as SUMIF function in my sheet summary. I need to have it add together all the percentages"Capacity Rating." The goal is to be able to create a SUMIF for each project manager in the division so we can see what their workload capacity is before assigning projects. I've used the…

Answers

Paul Newcome ✭✭✭✭✭✭

08/28/20

Based on your feedback from all of the troubleshooting we have tried, the data should be coming through. At this point I would suggest reaching out to Support. Feel free to revisit and post the cause/solution if you are able.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Trending in Smartsheet Basics

Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%
Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

SUMIF #NOMATCH Error

Answers

Categories