-
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…
-
Best Practice: Intake Sheet & Secondary Sheet when 2-way sync is needed
We're working on a solution for a department that is similar to Uber without the bells and whistles. A call comes in when there's bad weather, a city employee "aka Dispatcher" looks to see who is available in our list of drivers and assigns them to pick the employee up. I think my question is pretty simple? I'm having…
-
publish not showing up for grid/reports, but showing up for dashboard
as described in the question, why isn't there an option for me to publish my grid/report for me to embed? but i can publish a dashboard. would like to make the grid editable without using a dynamic view
-
How do you see which reports are connected to a sheet?
Hey everyone! I am trying to track down all of the reports that are connected to a sheet. I am planning on rebuilding the sheet but know that it is connected to a lot of reports that other people in my company use so I don't want to miss anything. Is there a way to pull a list of all reports that have this sheet as a…
-
Sheet Summary Report - Want to Use "Current User" Functionality
Hello, I created a Sheet Summary Report, and have found that the "Current User" functionality is not shown for selecting? Am I missing something in order to be able to do this? Or should I submit an enhancement request for this functionality? If it's not current functionality, is there reasoning behind why a Row Report…