The Formula that I am using is. Formula. Day calc - Set the day to the same day as the target date. I'm guessing it would of given me "No Downtime/Delayed mins" if there was an error? I'm trying to get duration to display XX hrs XX mins and if there's an error, to display "No. I have a formula that works with one Criteria range however it is not working. BethWork . Rows 1 & 3 meet the criteria. Thanks. 数式が以下の状況にある: 2 つの範囲をとる関数にて、関数に対してそれぞれの範囲の幅が合っていない。 関数に引数が入っていない。 引数内にさらに関数がある。 解決方法Answers. I realize that my Date Submitted cell sometimes is. I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Several of the date have long passed and are returning a negative number. I am now trying to Sum the minutes and then divide Minutes by count to get an average. Here is my formula: =VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. But, it's not working with message 'incorrect argument set'. One way that might work could be to use the Change Cell action in a Workflow combined with cross-sheet formulas (VLOOKUP or INDEX/MATCH, but I'm unsure if it will trigger from another sheet. 2307647 Programming session hours is 1. I want it to look at the Discovery Completed column and if the box is checked then it should display the information in the cell for the Implementation Project Stage. This same equation has worked while using it on the same sheet, however, this equation is referencing a different sheet. Day calc - Set the day to the same day as the target date. In another sheet I am collecting the following data: Model # Toner Color; And I want to RETURN the item ID. Right-click the column header at the top of the column and select Edit Column Properties. Can someone help me. See full list on help. But, it's not working with message 'incorrect argument set'. The Formula that I am using is. I have table Codes with "Customer-Job", "JobCode" and "Price" I have table Accruals where I choose the customer from a. Create and edit formulas in Smartsheet. The above returns #INCORRECT ARGUMENT SET. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums. Categories. Smartsheet doesn't allow for that (the clicking of the Column Name), like Excel does. This is what is causing your "Incorrect argument set" issues; you would use OR if you have 2+ possibilities for an outcome. Formula combinations for cross sheet references. I keep getting either Unparsonable or Incorrect Argument Set =COUNTIFS([Event Type]6:[Event Type]941, "Tag 1", [Event Type]6:[Event Type]941, "Tag 2", [Event Type]6:[Event Type]941, "Tag 3"). If the task is complete and also done by ricky torres, then add it up. All of the columns in both smartsheets are in the same. Here is my formula: =VLOOKUP ( [Helper. Multiple SUMIF Criteria formula results in #Incorrect Argument Set or #Unparcible. =SUMIF({Butler - PROJECT MASTER -. Correct the range size or arguments, adding or removing arguments in the formula. I'm using this in a cell to average values in another sheet. Any guidance would be. I am a new user and struggling with some IF statement rules to set color status. Thanks for the answer, Julio. Want to practice working with formulas directly in Smartsheet? Check out the Formula Handbook template! Trending in Formulas and Functions . then VLOOKUP returns incorrect results. I have a formula that works with one Criteria range however it is not working. IFERROR does not work on ALL errors. =avg (collect (range to average,criteria range 1, criteria 1, criteria range 2, criteria 2)) I tried this and I am still getting the argument. I want to count the number of contacts in an associated contact column and display the number of people as the icon. SMARTSHEET EXPERT CONSULTANT & PARTNER. It shows only 1 hour, even though I added the decimal spaces. Make sure they are both the same size. Another thing to check would be the source sheet. I tried using an OR within the forumla and got an Incorrect Argument message, so I feel I am close:I'm fairly new user to Smartsheet and struggling with formulas i could create in excel. On the Dup Sheet, we are going to add a text/number column and use this formula:. Hello @AFlint. Thanks, It is giving me a #INCORRECT ARGUMENT. I have a formula that works with one Criteria range however it is not working. Here is my formula: =VLOOKUP ( [Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. Now I'm trying to create an overall sum of Laserjets by using the following formula: If I interpret how SUMIF works in SmartSheet, this formula looks in the Inventory Item cells 1-86 for the word Laserjet and returns the sum of the associated cells in the In Stock cells 1-86. If it helps, you can click on one cell in the column to automatically populate the column name once (with a row reference to indicate where the cell is located). I have a formula that works with one Criteria range however it is not working. Smartsheet functions list. Not sure if using correct one. The Formula that I am using is. 5 hours. Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else. =COUNTIF ( [Task Name]: [Task Name], " Workshop B", [End Date]: [End Date] > TODAY ()) If function based on multiple columns. Sheet Summary QuestionHi cghallo_Veolia . Can anyone tell me why this formula returns an "INCORRECT ARGUMENT. @Issa M. Part 2. Unsure where my errors are on this one. Days Hours Minutes and Seconds. @JoanGuarin You have a cross sheet reference in the formula. Scott Murray . For the most part, I am pulling from the status column called “Capability - Stage Gate Status”. Formulas. =COUNTIFS({OTP Goals Project Lead}, CONTAINS(Contact@row)) the OTP Goals Project Lead is the sheet that has the column that is a contact list that allows for multiple contacts. =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. =SUMIF({Butler - PROJECT MASTER - Inte. Hi @jmalaguez. I'm using the "helper sheets" technique to help me copy specific column data from 1 sheet into another. To reference the whole column and make it absolute, you will need to make it as [Status]:[Status] OR select the first cell in the column and drag down to the last cell. Multiple SUMIF Criteria formula results in #Incorrect Argument Set or #Unparcible. In part of my duties, I run a report that shows activities entered on a form from yesterday. Then I added the formula to the bottom row and entered '8888, and it gave the cell a. WORKDAY ( [Date Submitted]@row, TODAY ()) is the number of days from the date of submission to current date. Three experts answer with explanations, examples and links to. The Formula that I am using is. . I am trying to narrow my conditional formatting for an order dependent on 2 different parts---I created 2 condition columns for a line item, First Condition Column "Y/N" and Second Condition Column "Y/N"However, now I've applied it to the column, I've realised there's a mistake in my logic to how I set up the formula, as the tasks that are 100% are calculated to be "Overdue" and all other tasks (whether not started or in progress) are "Complete". I am tracking completion of trainings by participants in our organizations using the Symbols fields and I would like to have one column that tells me if each participant has completed at least 1 training. I am able to achieve the counting of withdraw/rescind less than one year with the below formula, but when I add contain I continue to get the response #INCORRECT ARGUMENT…Best Answer. 04/14/21 Answer . Answered . I have a sheet that I am using as a master VLOOKUP table. AliT. An ID matching and a multi-select cell containing a certain value. errors_as_exceptions () and your code looks something like this. You will need to either type out the name of the column, surrounded by brackets ex [Status]. Adding new rows shifts the ranges down but sometimes the metric formulas will read #INCORRECT ARGUMENT SET while other times the formulas still work but they aren't referenced properly so the numbers reported aren't correct. it works in Excel. Does moving rows from smartsheet A to smartsheet B increase the operating speed of smartsheet A? I'm curious to know if removing data. (Intro@row,"yes", 6, 0) you would still have an invalid syntax (#INCORRECT ARGUMENT SET error), but even so Smartsheet should correct the spacing to add a space between Intro@row, and "yes". This shouldn't throw the #INCORRECT ARGUMENT SET error, but it could be an issue once we get that particular bit fixed. I would like all date results retuning negative numbers to simply return as zero. In this case, you should check "Edit Reference" range in your formula to make sure whether they point to the main sheet or not. If the task is complete and also done by ricky torres, then add it up. I have a formula that works with one Criteria range however it is not working. Create and edit formulas in Smartsheet. We'll call Sheet A "Roster" and Sheet B "Grading Sheet" Sheet A has columns for "Employee Number" and "Email Address" What I am trying to do is on Sheet B, have a column in which you can enter the employee number, it reference Sheet A and then it will automatically. part one works ok =COUNTIF ( {0-5 IMMSUNISATIONS Range 2}, =0)Answers. In this instance you would need to have a reference sheet with all possible contact combinations. 05/01/20 edited 05/01/20. Smartsheet functions list. It has a list of 50 items, and all I need is for them to click on a check box if they want that item. =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. True (the default value) assumes that the range is sorted ascending and. INDEX/MATCH, or INDEX/COLLECT) to locate & import a targeted cell. The Formula that I am using is. Syntax DISTINCT ( range ) range — The group of cells to evaluate. I can get both parts to work separately but cannot get them to combine to give a single result. Hello, I am looking to gather metrics from a sheet of QC submissions. Both sheets can be linked through the interrelation they have, although the teams sheet have multiple times the department across rows (E-G:…Multiple SUMIF Criteria formula results in #Incorrect Argument Set or #Unparcible. Visit us: I need some help with a formula that is currently yielding #INCORRECT ARGUMENT SET. I'm still getting an INCORRECT ARGUMENT SET. Unsure where my errors are on this one. You could display the numbers in the Dashboard by putting the Report data on the Dashboard through a collapsed Report Widget instead. But can't get the automation to copy a row when the cells criteria change on a vlookup cell. We do achieve "yesterday" by using the following formula: =IF(DATEONLY(Created@row) = DATEONLY(TODAY()) - 1, "Yesterday", "Not Yesterday") In using this formula we have noticed some alarming discrepancies. =COUNTIFS ( [Task Status]: [Task Status], "Completed", [Contact (s)]: [Contact (s)], " ricky torres ")Below is the formula that I currently have in place but it is giving me #INCORRECT ARGUMENT SET. I have a Coordinator Column as the reference point. Categories. I'm staring to think that INDEX will only work with an entire column as the range, and if this is so, it should be reflected in the documentation. Hi Smartsheet Community, I've already perused a number of Community postings related to this formula, but I can't seem to work it out. I am trying to get and if and formula to work that references values in another sheet but keep getting 'INCORRECT ARGUMENT SET'. #INCORRECT ARGUMENT SET. =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. These numbers are NOT updated. Sheet Summary Question Hi cghallo_Veolia . For {End Dates},< TODAY() , the formula is counting the end dates that are in the past from today's date. I have a formula that works with one Criteria range however it is not working. Thank you in advance for your help! ·. The Formula that I am using is. . The column. I am getting an "Incorrect Argument" on a SUMIF formula. I'm using the "helper sheets" technique to help me copy specific column data from 1 sheet into another. =SUMIFS ( [Inspection Type]: [Inspection Type], "Capital Needs Assessment", [Contract Stage]…. Categories. - Smartsheet Solution Partner. Why am I getting an #Incorrect Argument Set when all I have done is change the Reference table?. Ensure that this sheet has the system column "Modified Date". All of the columns in both smartsheets are in the same location. Example: -misspelling . I am trying to figure out what is wrong with my formula to cause this issue. Users choose from a drop list. So: CONTAINS ("Ready Shack", {Descript_Ready_Shack}, @cell)) I'm guessing that you're getting the error, because the CONTAINS statement is trying to evaluate the entire. For example, a multi-select column with each possible combination on the left, and a contact column with the Contact equivalent. However, as you may see above, there's a lot of model numbers in one field in a multi-select. I was wondering if I could please get some help. Sub-Category = "Key Initiative". [Ticket Status]@row = "Backlog". The Formula that I am using is. All Categories; 13 Welcome to the Community;Try inserting a second and third closing parenthesis after the final INDEX/COLLECT. Ex: =MEDIAN (COLLECT ( [Column to find Median]: [Column to find Median], [Column 1]: [Column 1], "Criteria. 04/14/21 Answer . Smartsheet functions list. In this example, there is a. IF Statement Returning Incorrect results. In regards to your question about a 1:1 with a Smartsheet employee, based on the account associated with your email address you are a licensed member of an organization with a Professional Support package. it works in Excel. Formula –. I am getting an "Incorrect Argument" on a SUMIF formula. !. I'm using this in a cell to average values in another sheet. Reports. On my target sheet, I have these same columns in addition to other data. Below is my formula: Hi @Amy Evans, it looks right. If you just wanted to average the Completed - Duration where the duration is less than 100, you would only need to list the range to average and the criteria: =AVERAGEIF ( {Completed - Duration}, <100) Note: for evaluating text values, the equal sign before the text value "TOP" isn't strictly necessary. Create a workflow to recognize that new cell input and trigger a Request Update with the relative rows that need updating. Há uma função extra no argumento. Smartsheet doesn't use percentage in their formulas so you will need to select percentage as a format for the cells in the column. Create and edit formulas in Smartsheet. I have a formula that works with one Criteria range however it is not working. Maggie Martensen. I have tried several other ideas without success. If you copy and pasted it to a new sheet you will have to update the cross sheet references in that new sheet. =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. In part of my duties, I run a report that shows activities entered on a form from yesterday. All Categories; 13 Welcome to the Community;Resolution. @RickyT Ok, so you will need the COUNTIFS formula, not the SUMIF since you have 2 criterion and since there are no numbers to add. Smartsheet functions list. . I have a summary sheet, pointing to another sheet where I'm gather median hours based on a specific criteria in a column formula. In this sheet: 1) Create a Text/Number column named "Timestamp - Status In-Progress or On-Hold" (or something more preferrable). 06/20/20 in Formulas and Functions. Hello, I am looking to gather metrics from a sheet of QC submissions. In the Matrix, I will have all the property. Multiple SUMIF Criteria formula results in #Incorrect Argument Set or #Unparcible. I am able to achieve the counting of withdraw/rescind less than one year with the below formula, but when I add contain I continue to get the response #INCORRECT ARGUMENT…Best Answer. This same equation has worked while using it on the same sheet, however, this equation is referencing a different sheet. Incorrect Argument Set means there's either an issue with the range sizes (ex. I'm trying to follow this but getting the #INCORRECT ARGUMENT SET erro. But can't get the automation to copy a row when the cells criteria change on a vlookup cell. The Formula that I am using is. I have the same problem with @cell in month () formula that is not working. 3) Time Spent. smartsheet expert consultant & partner Andrée Starå | Workflow Consultant / CEO @ WORK BOLD W: | E: [email protected] | P: +46 (0) - 72 - 510 99 35 Issues with TODAY() and daily reporting. Enter the VLOOKUP formula with your four arguments. However I agree with Mark, the real answer is for smartsheet to provide real data entry validation at least to the level that excel offers in its basic functionality. Set up your chart. Looking for assistance on how to apply this formula to the entire column. I've been added responsibility for another company/brand, have purchased smartsheet licenses for that brand, have an email address and login separate for that smartsheet instance and now I want to duplicate sheets between accounts. This same equation has worked while using it on the same sheet, however, this equation is referencing a different sheet. =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. such as leaving out required parameters, incorrectly spelling words, or not separating arguments with commas. Formula combinations for cross sheet references. I am trying to add the total from the count of 2 sheets given the criteria. Formula I have:. Thank you!. smartsheet expert consultant & partner Andrée Starå | Workflow Consultant / CEO @ WORK BOLD W: | E: [email protected] | P: +46 (0) - 72 - 510 99 35I'm trying to create an IF statement that relies on the data in 2 cells. Multiple SUMIF Criteria formula results in #Incorrect Argument Set or #Unparcible. com | P: +46 (0) - 72 - 510 99 35. There are three methods you can use to pull data from a range based on a matching lookup value: VLOOKUP INDEX (MATCH ()) INDEX (COLLECT ()) We’ll review how to use. Set up your chart. criterion1 [ criterion_range2 criterion2. I have 2 sheets. W: | E: [email protected] with TODAY() and daily reporting. Unsure where my errors are on this one. =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. xls and click the VLOOKUP Self-Contained worksheet tab. #Incorrect Argument Set. Create a workflow to recognize that new cell input and trigger a Request Update with the relative rows that need updating. Troubleshooting smartsheet unparseable errors can be tricky, but following these steps should help you identify and fix them quickly. I have a formula that works with one Criteria range however it is not working. Categories. Countif "Incorrect Argument Set". The Formula that I am using is. I have a formula that works with one Criteria range however it is not working. I do appreciate the help, you're putting out some great info, I think I'm just rusty or missing something but i'll try again. Now this works perfectly! So in a cell right below that one, I then try to count rows in Sheet A where both of these criteria are true: Done = 0. Por. This same equation has worked while using it on the same sheet, however, this equation is referencing a different sheet. I cannot find ANYTHING in the activity logs for any of those 4 sheets (the only sheets connected to each other) for around the same time that would add up to being the reason for this. Unsure where my errors are on this one. I have attached a few screenshots that might better explain. you set the Column you want to evaluate at the very beginning, then you list out each column and criteria afterwards. Have also Tried: =INDEX({Budget Day Rate}, MATCH(1, (Loc7 = {Budget Loc}) * ([Column3]7 = {Budget Role}), 0)) The above returns #INVALID OPERATION {Budget Day Rate} = The day rate column in a rate card sheet {Budget Loc} = The Location Column "UK" "US" etc {Budget. Thank you,@deb_63_hydracor. Multiple SUMIF Criteria formula results in #Incorrect Argument Set or #Unparcible. Unsure where my errors are on this one. I'm trying to apply the same principle for the second formula, but it's advising me INCORRECT ARGUMENT SET. Smartsheet functions list. The Formula that I am using is. I have a formula that works with one Criteria range however it is not working. If you amend the range details that should sort it for you. I tried to do so with a Cross-Sheet Reference, but the reference endlessly processes. summetg . =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. Formula combinations for cross sheet references. The formula works in Excel but not in Smartsheet, I'm getting an #incorrect argument set. Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely. In addition, I wanted to add some criteria for other scenarios, such as the Start Date is past and % is 0%; the Start date is the future, or the. I thought I’d found the answer to this in a forum a while back, but the answer on there didn’t work for me when I tried it – I’d like to know if there’s a code/formula for Smartsheet to check whether an End Date (publication date) falls on a Thursday and for Smartsheet to automatically move the date along to the… I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). if you want to average based on multiple criteria you should use. The Formula that I am using is. The current formula in the Tenure Category is below and returning #INCORRECT ARGUMENT SET so I'm sure something is off but not sure what it is. 03/23/22 in Formulas and Functions. Formula using WORKDAY, TODAY, ISBLANK - #INCORRECT ARGUMENT. =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. I am running in to an error on a metric sheet i have created which has me stumped. For example, 1, 2, a,. 4K Get Help;#Incorrect Argument Set. :(I'm trying to get median of Days on Q2 and so used formula as below. Categories. The one idea I had that I couldn't execute on was to have my JOIN/COLLECT return my results with a identifiable delimiter (such as "@" or something that wouldn't be in my data source), the cut up and recompile the list in another cell, taking the first 20 characters after the @. this will work. I have a formula that works with one Criteria range however it is not working. Apologies, I am still learning Smartsheet (and coding :-)) Also, to add a bit more context, I am unable to do a "contain" to look for any value that contains SAP AP Export, because I have multiple interfaces that are unfortunately named the same (I tweaked the name with PowerAutomate. Formulas and Functions. Hi @Daniel Barrett. =COUNTIFS ( {Active Leads Range 11}: {Active Leads Range 11}, "Mark", {Active Leads Range 10},"Bidding")Count Function and Symbols. Then the 1st criterion range, then the Criteria. Unsure where my errors are on this one. =COUNTIFS ( [Task Status]: [Task Status], "Completed", [Contact (s)]: [Contact (s)], " ricky torres ") Below is the formula that I currently have in place but it is giving me #INCORRECT ARGUMENT SET. This same equation has worked while using it on the same sheet, however, this equation is referencing a different sheet. The Formula that I am using is. When looking at percentages, Smartsheet using 0=0% and 1=100%. Hi All I'm very new to Smartsheet. The Formula that I am using is. Smartsheet Processing Speed. I can't find my original formula but I did check this one and it works. I'd like to achieve the symbol results in the "Indicator" column based upon entries in "Client Status" and "RCM Status" columns. Just sharing in case it helps someone. =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. Multiple SUMIF Criteria formula results in #Incorrect Argument Set or #Unparcible. I have a formula that works with one Criteria range however it is not working. I am trying to sum a total with multiple criteria (a name descriptor and a date). An ID matching and a multi-select cell containing a certain value. I have a Status column that in it's simplest definition needs to return the values "Complete", "In. Users trigger their own. Please see below: That's the formula: I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. I have a formula that works with one Criteria range however it is not working. =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. In my image above, I have 3 contacts. The yellow cells use @cell = [email protected] have had #INCORRECT ARGUMENT SET show up on both sheets #3 and #4, in the columns that use cross-sheet refs. Smartsheet functions list. I need the duration to show blank if there is an start date and no end date. What is the formula for Smartsheet? Looking to Countif a person's name is contained in a column that allows for multiple contacts. If I use this range on COUNTIF (no S on it), it works perfectly but, when I include in COUNTIFS, it does not work. I think I used the below formula or something like it. =SUMIFS({Estimating Range 1}, "Civil", {Estimating Range 3}, 9, {Estimating Range 4}, 2020, {Estimating Range 2}) I am trying to use a SUMIFS formula to capture a dollar value as stated in Estimating Range 2. I checked the parent source of all of this information and I didn't see any errors in that sheet. It turned out that I needed to change the values both in the Standards - Scope of Work sheet and in the column values in the intake form by editing the form itself, rather than editing the column on the spreadsheet view of the intake. Ex: [Column Name]7. I have a formula that works with one Criteria range however it is not working. I'm struggling with a formula to check a reference sheet for two conditions. Not sure if using correct one. All Categories; 13 Welcome to the Community; 4. Hi everyone. Here is the concatenation formula I am using: = [Ajera Pod]@row + [ConceptShare Pod]@row + [Costpoint Pod]@row + [Talent DLZ Pod]@row + [Talent DTM Pod]@row + [Vantagepoint Pod]@row + [Vision. 67. This same equation has worked while using it on the same sheet, however, this equation is referencing a different sheet. In part of my duties, I run a report that shows activities entered on a form from yesterday. 2. i am trying to rank top ten users. 2) Create a Text/Number column named "Completed Date". (see below) Then, I worked on the metrics sheet to show the hours on the programming session - Complete. " =IF (AND (Start@row < TODAY (+30), [% Complete]@row < 1, "Yellow", "")) ·. You can Sort the Report so it shows the rows in order as well. In. Assuming MH Client Profiles V2 Range 3 is the sum reange, it would look like this: =SUMIFS ( {MH Client Profiles v2 Range 3}, {MH Client Profiles v2 Range 13}, "East", {MH Client Profiles v2 Range 16}, 1). (blank) still moving over when I run a manual test? Column is set as text/number. The logic on the target sheet will never have more than one check box selected. Here is my formula: =VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. AliT. In the first formula, the conditions to be met are that if both columns of Date Received are not blank, another column for In-house testing is unchecked, and 4 columns following In-House testing remain blank, that the value returned is 1. You can do the datepart within a lookup formula but this way makes it easier to reuse this info for other summary visuals like the report below this. (Please let the Product team know of your request by filling in this form, here!. Needing help with the COUNTIFS and referencing other sheets. Categories. I want this column to show "N/A" or be blank if the Resource/Object type contains "guidance. =SUMIFS([Inspection Type]:[Inspection Type], "Capital Needs Assessment", [Contract Stage]:[Contract Stage], "7. g. I gave it a try and I am getting #INCORRECT ARGUMENT SET. Multiple SUMIF Criteria formula results in #Incorrect Argument Set or #Unparcible. Yes! It worked! (The commas formula) Thank you! Excellent! Happy to help! Remember! Trying to figure out why I'm getting the Incorrect Argument Set with the following formula. The Formula that I am using is.