-
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,…
-
Merged: Create Simple Report from Sheet
This discussion has been merged.
-
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…
-
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…
-
Customize hyperlink destination in reminders/notifications
I tend to use a lot of large sheets with contributors from multiple sites interacting with the sheet through reports, and use automations to notify users when they need to input information in their report. Unfortunately, the notifications link back to the sheet itself and not to the user's report. It would be very useful…