-
index and match not working right!
hello everyone, for the life of me i cant get the index and match to give me the data i want to see and i know i have missed something simple. my main sheet is "Master NSW Schedule" (MNS) i have a secondary sheet meant for other users "DETAILING SCHEDULE V2.0"(DSV2.0) this is to hide certain information from them but the…
-
Urgently need help with a formula!
I have a sheet used to maintain a list of projects, I will call it "Master Project List" and I have a second sheet that the team uses for scheduling which I will call "Scheduler". Team members use a form to enter their planned hours on a project into the Scheduler which includes the project number and the task name. Each…
-
Formula to calculate future annual date after initial maturity date has expired
I need to create a new column date in the future on an annual basis when the initial maturity date has expired. Below are the 3 columns I use to determine the initial contract end date based on effective date and the term. After the initial term the contracts then renew on an annual basis. Every contract period end date…
-
New Functions Feature Request
"ROW" - used to reference the sheet row number that can be referenced in other formulas. Something like '=ROW@row' 'PREDECESSORS' = similar to current 'SUCCESSORS' function but returns the row references for predecessor tasks in dependency enabled project sheets. '
-
Calculating Time Between Two Different Dates
I am having some difficulty finding the optimal solution to a problem I am having with Smartsheet. Right now, I have a large sheet which has time on one axis (column A is every date between 1/1/2018 to 1/1/2019). For example, for rows 1/1/2018 - 1/3/18, there is a starting time on 1/1/2018 (example, 8:00:00), and then an…
-
Collect Date
Hello everyone, i have been trying to find a way to collect dates from a column that follows some criteria. Tried with index collect but i obtain always the 1st date that follows the criteria and when trying to incorporate a 2nd criteria i got incorrect argument. I have prepared one test to show what I want: What I try to…
-
Index Match Match returning completely wrong values
Hi Team this is the formula =INDEX({Sales and Transfer Calculation _sold}, MATCH(SKU@row, {Sales and Transfer Calculation_SKU}, MATCH([Closing Date Range]@row, {Sales and Transfer Calculation _Date}, 0))) its returning values but not the right ones. Any ideas? thanks in advance Chris
-
Why isn't our column formula updating on its own?
In our column formula, we have a date formula based on TODAY(), however, it does not seem to update automatically when the month changes. How do I get it to update automatically at the beginning of the month?
-
Averageifs with multiple criteria
Hey! I'm trying to return the average of a task that is completed from multiple houses I need to check whether it is the task I am looking for and if it is complete, and then return the average duration for the tasks that follow those criteria If averageif had multiple criteria I could do this easily, but it does not ND is…
-
Count Distinct Collect - Unique Values Several Columns - Help
Hello! I am trying to get the unique number of countries that have a value greater than 0 from a set of columns, the formula works, if I just collect from one column, example below, I get what I want, but if I try to add Carlos's Colum or others to the formula, then it does not work or just returns 0 or 1.…