-
Merged: Report over sheet that have a published with edit rights link
This discussion has been merged.
-
Metric Widget/Reports Formatting on Dashboard
Hi Guys, I'm just diving into dashboard creation, and am adding Metric Widgets and reports on my sheet. My question is there a way to modify the width of the columns? It seems like the columns are the same width, with no way of modifying them. I'd like the date column to by thinner, and the desctription column to be wider,…
-
Working with reports in card view
I have a project sheet with 3 specific columns; STATUS (dropdown with specific statuses - Submitted, Assigned, In Progress, and Closed), ASSIGNED TO (contact list with specific employees that can be assigned), and TASKS (dropdown with specific tasks to be assigned). I trying to write a report in Card View that I can View…
-
Ability to add rows directly from within a Report
Reports are a great way to visualize data in the way you'd like: filtered, grouped, summarized, and sorted. The problem is they lack the ability for a user to ADD a row. Example: If I give colleagues a filtered view of data that are relevant to them (say, from an underlying sheet they don't have access to), they can easily…
-
Why automation copies the row 3 times instead of once?
Hi everyone! On Smartsheet, I have a source file for which I created an automation. Through this automation, the 7 rows of the source file (whose values are updated multiple times a day) are copied to another destination file. According to the automation, the copy should only occur once a day at 4:00 p.m., and the goal is…
-
Place Months in chronological order on a Dashboard Trendline Chart Widget?
Context: I am building a trendline report to track number of projects started each month. It has two series, a 2024 and 2025 series. Two keep the months in order, I have put a number in front of the month, e.g. "03. March" so that when I create the trendline the months are not out of order. (e.g. in a previous iteration…
-
Consolidate Columns in a Trendline Report
Context: I have created a trendline report that counts the number of projects started each month. I've done so by building out three separate columns that determine the month and year so that I can then plot it on a trendline graph with a 2024/2025 series. The Chart: How the data is organized: Month Formula:…
-
Can automation reference another grid as a trigger?
Is it possible to create an automation that triggers off a different grid (grid 2) where that information is not copied to grid number one? Example, when grid 2 column NAME says Mike send information via automation from grid one to a Mike via email?
-
i am not able to sort in smartsheet reports when Multiple source file(sheet) is selected?
I am trying to sort based on the YTD summary, which is a numerical value, but Smartsheet won't allow me to sort it, it sorts automatically based on the alphabetical order which is available on primary column. Anyone faced this issue or have any solution for this?
-
Can I see all of my comments across sheets and reports in one place?
I'm wondering if I can see a feed of all my comments across sheets and reports somewhere... I know we can select "All" in a sheet's Conversation panel, and we can only see comments in a report if we select a row. Since we use a mix of sheets, reports, and WorkApps every day, having ONE place to see all of my comments would…