-
Help with INDEX/COLLECT with a MAX/COLLECT
I am attempting to create a few reference columns using an INDEX/COLLECT function and incorporating a MAX/COLLECT because there is a 1-Many relationship on the RTO Queue ID in the 2nd sheet so I would like to use the row with the MAX Fully Executed Date. Below is the formula I am using: =INDEX(COLLECT({IA Assigned}, {RTO…
-
Is there a way to break out found Rows from a LInked Sheet into sequential rows in a new sheet?
Hi folks. Let's say I have a sheet with the following data: Then I make a second sheet that links to the first, looking for matches of both the Name and Date. What I want, in this second sheet, is to eventually show that on 12/25, Matt is Eating a Sandwich (first row of new sheet) and Using the Toilet (second row of new…
-
Question about what Data Shuttle Run Options
Hello, I am not sure i understand what the scheduler means in the data shuttle I have set up. Does the below mean that my scheduler will run every hour from 5 am to 8 pm each day? I need it to update often but not sure if this will do it or not. Thank you to those that are smarter than me :-)
-
Hyperlink manual trigger data shuttle workflow
As of now the data shuttle workflow can only manual trigger in the data shuttle page by clicking on "Run". My idea is to allow user to trigger running a workflow by hyperlink/webhook. So user can add the link in their dashboard as a function of Button. To manual trigger the data shuttle workflow when they are reviewing the…
-
Why did your support AI bring me here to cancel my subscription?
Your AI bot shared with me when I asked for support that I could not access a live human or email address and recommended I go here since I don't have the privelege of support. Can someone from SmartSheet please contact me by email so that I can cancel duplicative recurring charges on my credit card that you are charging…
-
Is there a way to proactively include the three baseline columns in blueprint within Control Center?
The challenge I'm facing is that these columns aren’t created until the baseline is saved on the sheet—after it's already provisioned via SCC. I’d like to add them to the blueprint template sheet ahead of time so they can be incorporated into my profile data and made available for reporting. How can I do that?
-
Failed to Import (error)
I am trying to import (just blank rows, with 18 columns) from Excel into an existing sheet, so I don't have to recreate the 18 columns into my tracker. But I get a "Failed to Import" error. HELP!
-
Helper Column Parent Rows
Hi! I'm trying to create the helper column to ID a Parent Row so that the sub rows show up in Reports. Right now, I'm using this formula for this sheet, but I get a "No" despite the fact that all the rows have sub rows. any ideas on what I'm doing wrong?
-
Subtracting Months from a date, Error #Invalid Value
I have three columns. One with a date 7/1/2027 in date format. One with a number representing the number of months I wish to subtract from the date column. Third column is a date column with the following equation: =DATE(YEAR([Column4]@row) - INT((MONTH([Column4]@row) - VALUE(Factor1)) / 12), MOD(MONTH([Column4]@row) -…
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…