-
Does the change in value within a formula not count as a change?
I'm trying to create an automation. In this automation, I want to copy rows when a value changes based on a formula (a count from another sheet), but the automation isn't triggering. What could be causing this issue?
-
Invalid Operation Error on Dashboard but not on Report
Hello, I am using the Smartsheet Dashboard to communicate production status to colleagues. I have a widget on the dashboard meant to display the overall status of the manufacturing run by pulling the status of the last item on our task tracker (Condition37). The tracker is displaying the correct status, in this example…
-
Best formula to link data in another cell
Hi all, I wanted to know what the easiest way would be to link data from one sheet to another. I have working cross-reference formulas, cell-link, and even just using miscellaneous formulas to reference them, just as proof of concept. I was wondering, what is the difference between using Index-Match to pull in data, versus…
-
Allow Column Linking with Auto-Number Fields in Table View
Description: In our grant process, applicants submit an application which is assigned an Auto-Number (e.g., FAC-00001) — this becomes their official Application Number. When a grant is awarded, recipients are sent a unique URL to a report form where the Application Number is prefilled. We would like to link the Application…
-
seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
-
linksOutToCells return as null
I've tried using the C# SDK and directly to the API. In both cases the get specifies include=crossSheetReferences when getting the sheet. The Rows are returned and the Cells contain the correct data but in each case the linksOutToCells is null. What am I missing?
-
Set Task Duration from Formula
I have a project with many repeated subtasks, and sub-sub tasks. To generalize: Task A has Subtasks 1, 2, 3 Each subtask 1, 2, 3 has sub-sub-tasks a, b, c I would like to describe the duration for Subtask 1 with a, b, c in a general set at the bottom of the sheet. Can I link the duration of Subtask 1, 2, and 3 to the…
-
Unable to Change or Delete Any Dates
I am unable to change any dates in my project schedule. It does not matter if it is a blank cell, automated cell, manually entered cell, new line I create, existing line, etc. — no matter what, if I attempt to modify a date, it just enters as 9/11/2025. This started last time I used my file. I have made sure cells aren't…
-
Links Not Working
Anyone else having issues with links to other Smartsheet sheets not working on and off? This is the second issue I have had this month. My table is not populating with the little arrow for the link showing as red versus blue. Error message says: Error: this link is invalid because the linked cell has been deleted. But, if…
-
Primary column data to other Sheet
I have 2 sheets, Sheet A has Primary column and I want to copy Sheet A primary column to sheet B. Sheet A has 2000 lines in primary column also whenever I update Sheet A primary column I need it should be updated in Sheet B too. how I can do this in Smartsheet?