-
Data mesh: Merging between sheets
I have 3 sheets: 2 of them have their own forms to collect data, and 1 master sheet. The 2 individual sheets have questions which are similar to each other and questions which are completely different (they are 2 forms of questionnaires). The master sheet is used to merge the answers of the similar questions and all other…
-
How Can I Resolve #INVALID Errors in Automated Capacity/Utilization Report?
Hi Smartsheet Community, I’m running into #INVALID errors in a resource management report and can’t seem to track down the root cause. I’ve attached two visuals for context: A screenshot of the report showing which team members are affected (#INVALID appears across all months for some users like Jerritt and Danny). A data…
-
Automation option: Copy value from another cell in the same row
Provide an Automation option under Change Cell Value to "Copy value from another cell in the same row". This is necessary when managing data with data shuffle and cross references. It is the only way to automatically capture data snapshots when certain conditions are met, or one-time replace data when certain conditions…
-
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…