-
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. '
-
New Function - "PREDECESSORS"
"PREDECESSORS" = similar to current "SUCCESSORS" function but returns the row references for predecessor tasks in dependency enabled project sheets. The values returned should be referenceable values in other formulas, e.g. omitting the SS/FS/FF task constraints in the dependency column so index/match formulas can be…
-
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.…
-
Cross-sheet VLOOKUP maximums
With the new cross-sheet VLOOKUP function, how many VLOOKUP cells can exist in one sheet? Does the limit change if there are both inbound and outbound VLOOKUPS in the same sheet?
