-
INDEX and MAX gets Invalid data type match
I have the reference to the MAX working correctly and pulls the newest date, but when I add it to the index to pull the information from the text field in the associate sheet I get invalid data type. Am I missing something? Can you advise? =INDEX({Display by Tech Range 2}, MAX({Display by Tech Range 1}), 0) Display by Tech…
-
Using Countifs in differents sheets and related with 2 columns
Hello everyone! I need some help. I'm trying to match a two formulas for each column, similar like these, |In Progress| =COUNTIFS({Progress}, <1, {Start}, >=DATE(2021, 05, 1), {Start}, <=DATE(2021, 05, 30)) ---- Result should be "2" since there're 2 dates in the column finish date with the month on May. (It should be…
-
IF NOT FORMULA with COLOR STATUS * HELP PLEASE**
WHEN (NO actual survey date entered yet) If Scheduled survey date is beyond 7 days from today date – Green If schedule survey date is within 7 days from today date – yellow If scheduled survey date is today or past – Red Once an actual survey date is entered it is – blue *** HERE IS WHAT I HAVE BUT WONT WORK**…
-
Trying to Selection Multiple values from one column
Need to select multiple values from a column to sum a different column. Where is this wrong please help =SUMIFS({Fastrack Total Cost}, {Fastrack Build Location},ME,{Fastrack Build Location},AK,{Fastrack Build Location},OP-UNIT3,{Fastrack Build Location},Unit 1)
-
Calendar View - can't drag tasks when Due Date uses WorkDay function?
My SmartSheet has Task Due Dates that are calculated using the WorkDay function. For example, if a recurring monthly task is due on WorkDay 1, that calculated Task Due Date would become Monday, January 3rd, rather than Saturday, January 1st. Approaching the dates in this way makes it easy for us to rollover the Task List…
-
Help with Creating IF Formula * PLEASE*
WHEN (NO actual survey date entered yet) If Scheduled survey date is beyond 7 days from today date – Green If schedule survey date is within 7 days from today date – yellow If scheduled survey date is today or past – Red Once an actual survey date is entered it is – blue *** GOT THE FIRST PART BUT CANT FIGURE OUT HOW TO…
-
Trying to find a value in Smart Sheet column the add up a Column
If {Build location} = AK then sum {WIP Calculation}. Tried this is says incorrect argument what is wrong =SUMIFS({Build Location}, "AK", {WIP Calculation})
-
Count the number of lines after a date.
Hello. Certainly a simple question for all of you, but not for me! I am trying to count how many rows were created after a certain date. For example: =COUNTIF({PDCA Commercial SLF-FP-001 Range 3}; > 01/01/2020). Thanks in advance.
-
Index/Collect Formula Error
Hi, I am receiving the error "#INVALID VALUE" on only the first row of my data and wondering if someone could help with where I went wrong in my formula? =INDEX(COLLECT({2021 KPI Scores Range 1}, {2021 KPI Scores Range 3}, @cell = [KPI #]@row, {2021 KPI Scores Range 4}, @cell = Region@row, {2021 KPI Scores Range 2},…
-
Forecast Formula
I am trying to figure out a formula for the following from a reference sheet: {Value Column} = SUM total {Date Column} = current YEAR, specific MONTH {Primary Column} = CONTAINS "Invoice" in Children to MATCH "Client Name" in Parent {Status Column} = "Forecast" ISBLANK if none of above match or cell is empty