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 Community Champion

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
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Would you benefit from getting my help in person?
0 · Share on Facebook Share on Twitter

Trending in Smartsheet Basics

unable to hide columns
I am unable to hide columns - the option is grayed out or unavailable. Any advice? Thank you
Map auto date field on PDF document
When generating a PDF for letters, I would like to auto generate the date on the top of the letter for the date the PDF is generated. I cannot figure out how to do this.
Create New Folders in Sheets Directory
I am trying to create a new folder in my sheets directory and it seems that we are no longer able to do this; is this correct? It seems that I can only create folders in individual workspaces. Whether I use the "create" button or right click > create, the only options now are to create anything BUT a folder. Am I missing…

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

Watch video

SUMIF #NOMATCH Error

Answers

Categories