-
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…
-
Help With If Count If to Identify Unique Values in a Column
I'm trying to make a helper column to identify if a new/unique project code has been entered in a column so that I know when a new project has been created. I've been trying to set up this formula and plan to then set up an automation to be notified when "New Project Code" has been entered into a cell. It seems to be ok on…
-
Merged: Override Column Formula for Particular Cells
This discussion has been merged.
-
Merged: Allow Drag-and-Drop Reordering of Summary Sheet Formulas
This discussion has been merged.
-
Merged: Use of sheet summary fields (or formulas) in automation
This discussion has been merged.
-
Merged: Enable Workflows to Reference Summary Sheet Fields
This discussion has been merged.
-
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?
-
Create Formula at Grouping level
Hi, I have a source (and detailed) Smartsheet page with a lot of "detailed" transactions/rows. I created a report where I'd like to group the data and get some subtotals at the same time. If you check the picture (my new report), I'd like to group by "Task Name" , sum the "Hours", return the max of the "Estimated duration"…
-
Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
-
Request for Update Report (or something like it)
Hi there! I'm hoping this group can help. I'm building out program/project management & tracking at my company. We have 8 grids (one for each dept) that funnel into multiple reports and dashboards. Within each grid/sheet, there are multiple projects that have CHILDREN project plans nested underneath. We want project owners…