-
INDEX/COLLECT/CONTAINS
I need to pull the Form ID (and other columns) from Sheet B into Sheet A. These conditions all need to be met: Departure Date ⇒ Date Field 1 Departure Date =< Date Field 2 Destination (Sheet B) contains City (Sheet A) Name (Sheet B) contains Last Name (Sheet A) This is the current formula I have: =INDEX(COLLECT({Form ID},…
-
The intermediary sheet not updating with the source
Hello, I have a destination sheet that is cell linked to a source sheet. The source sheet is constantly being updated (adding information, deleting information) but the destination sheet does not reflect those updates. Is there any work around this issue? Any way that the destination sheet reflects the updates real time? I…
-
Hot key for Expand and Collapse Row
As Business Analyst, I'm frustrated when working with large projects that I cannot expand and collapse with a hot key. I find it cumbersome to use a mouse to click the + or - on a row of nested rows to expand or collapse the nested rows. Ideally, I'd like keyboard/hotkey functionality tied to the expand and collapse…
-
How to Identify Which Smartsheet API Endpoints Our Organization Is Using?
Hi everyone, I recently received a notice from Smartsheet regarding upcoming API endpoint deprecations and the 90‑day warning period. As a System Admin, I was informed that users in our organization are actively using Smartsheet API tokens, and some older endpoints will be sunset by June 3, 2026. Before we make any…
-
Automating row expansion from Master sheet to Input Tracker using API or workflow
Hi Smartsheet Community, I have a Master Tracker sheet where PMs submit projects via forms. Each row represents one project and includes: Auto-generated Project ID Total number of inputs (e.g., 3–5 inputs) Input 1, Input 2, Input 3… fields with descriptions and remarks Currently, I manually copy each input related feilds…
-
Can you use 2 match criterias in an index/match formula?
I am looking to structure an index and match formula, but it needs to match two columns of data and having some troubles. Is this possible or will I need to create a work-around with a Join function in another column?
-
Auto-numbering Parent row with auto-numbering children using Parent number with suffix
I have sheet which auto-numbers a new entry for a new project. Some of those projects receive monthly entries. I would like to have the new entry (new project) have a primary ID with child rows by month. Ex: Project ID # 5526 - ABC Company (Parent) #5526 - Jan or 01, ABC Company - January, #5526 - Feb or 02, ABC Company -…
-
Issue with Future Dates and Global Time Zones
Hello Community, Looking for some help today to figure out how to correct time zone differences with dates. I have set up an Automation workflow to remove future dates in schedules and send notifications to the PMs. This would prevent future dates being collected in reports and dashboards. The settings for the Owner…
-
Date and Time
Good day. On my sheet, I'd like to find out if it's possible to calculate the elapsed hours of a job using the start date, estimated hours of completion (for the job) and finish date.
-
Dynamic View
Hi, One of the users for whom the Dynamic View toggle is on is getting the view blank.