-
Critical Path based on a release
I would like to see a critical path on a large project based on a release number. The critical path seems to be only available on a sheet basis. I can use a critical path filter that works great – but again works on a whole sheet. I was thinking about using a Release Number filter and then copying just those rows to a new…
-
Multiple Forms - Add info to existing row
Hello! We work with a registration form that feeds a master sheet, we want to add another form that will update or add a request for change for a registered contact, but we do not want to generate a new row, we want Smartsheet to match the name or ID to the initial registration and update the columns. Do we need a formula…
-
How to Display Clickable Links on a Dashboard That Update from a Metric Sheet
I need to add clickable links on a Smartsheet Dashboard that automatically update based on changes made in a Metric Sheet. I tried using a Metric widget, but the links appear only as plain text and are not clickable. Is there a way to have hyperlinks on the Dashboard that stay clickable and get updated whenever the Metric…
-
x-sheet reference - trigger for automations
Trying to trigger an automation that is not working b/c the source column is a x-sheet reference value. I understand tht x-sheet references cannot be the trigger for an automation to run on the destination sheet. I've added a helper column on the destination sheet that is a formula column that references the column that…
-
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…
-
formulas with percentage
I pulled in a number from another sheet, % Complete from Plan, that is a percent and want to subtract this from 100%. This is the formula I am using: But it renders #UNPARSEABLE
-
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?