-
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?
-
Return a single text value if either option A or option B from drop down list is selected
Hi there! Looking for help with a formula that will be able to return a single text value "Not Applicable" in Column 2 if either Option A or Option B is selected from a drop down list in Column 1? I think I'll need to use the IF and CONTAINS function but not sure how I might be able to join these two together? Thanks in…
-
Need Help with Approaching Due Date Formula
I have an Approaching Due Date column with the Star checkbox and I want to create a formula that will show the Star if today is between 7 working days in advance of the End Date and the End Date, and the Status is NOT Complete. I also have a column for Past Due with a Red Flag checkbox. I want the Approaching Due Date…
