-
Formula error help: Not Started, Complete, In Progress, Overdue
Hello - Looking for assistance to resolve #INCORRECT ARGUMENT SET error. I believe I am overlooking it, because I have been focused on it for too long. If the due date is in the future, I want "Not Started" Formula giving error: =IF([% Completion]@row = 1, "Complete", IF(AND([% Completion]@row < 1, [Due Date]@row <…
-
How to find part of a string in another sheet
I have a sheet with a string, say xyz, this is not always the same length. In another sheet an have a column of numbers, which have values which are variable-length strings with values which in the case of the xyz is abcd123xyz I need to find the row that has the xyz is the column. Is there a way to do this?
-
I am trying to tally a column by month
=SUMIF([End Date]:[End Date], MONTH(@cell) = 4, Pricing:Pricing) Trying to tally my pricing column if the 'end date' column is within the month of April. I am getting "INVALID DATA TYPE" @Paul Newcome - I have found your answers to other helpful in the past
-
how can i sync dates in a column with formula?
Hello, below, I will explain to you the calculation of the termination notice period before the expiry of a contract and the sending of the reminder e-mail to the responsible person according to this notice period; 1- In the first step, I enter the end date of the contract and the notice period on a daily basis. 2- The…
-
Complex formula using INDEX MATCH to update other columns
Hello Smartsheet Community, I am trying out how I can do an Index Match to look up data in column 1 and see if the data exists in column 2. If the data exists then update other columns ( like status , health and % Complete, Greatest milestone met) with Values Im truly in a time crunch , and will be super appreciative if…
-
Countifs Function with Multiple Criteria - Best Practices?
Hello! I'm having trouble understanding the best way to count multiple criteria in a countifs function. I can write simple countifs formulas, but the more criterion and ranges I add (seeking "and/or" results), the more errors I get. I struggle with combining ranges and criteria, I think because I don't understand how best…
-
Formula Assistance Needed
Wondering if you could help me with another formula in Smartsheet. What seems off about this one? =SUMIF([Payment Method]:[Payment Method], "", [Payment Amount]:[Payment Amount]),(Territory:Territory),(NOT("International")) I want to sum the "Payment Amount" column IF the "Payment Method" column is blank and IF the…
-
COUNTIF in Muti-Select Column
Good morning, I am trying to count how many times a name appears in a multiselect column, the problem is that when there is more than one name in the column it will not count it. Here's my formula so far =COUNTIFS({Construction Damage & Complaint Tracker Range 1}, "Gary" Although Gary's name should count 5 times, it does…
-
Calculating an average confidence level
I'm creating a metrics sheet that collects the confidence level ( 1 through 10 ) by month. What I'm trying to figure out is how to calculate or identify the average confidence level received. The diagram below shows that I have entries for confidence levels 7,8, and 10. How do I determine the teams confidence level is…
-
Sum months prior to current month
Hello, hoping someone can help me after trying to search for this issue on the boards. I have columns for every month of the year tracking project $ spent as well as projected to be spent in the future months. I'm trying to use a formula that will track the $ in the columns prior to the current month that can automatically…
