-
It’s so awesome to participate live in Engage!
Words can’t describe how great it is to meet all the Smarsheet people live finally after 3 years on working with Smarsheet from Europe. Everything is so tip top organized here. Positive energy on every corner. People are so friendly and devoted what makes this event very professional. Happy & lucky to be here. @Alison…
-
Using Power Automate Flow to add new row
Hi Community, I am creating a power flow that creates rows in SS based on an email. Everything works fine until I want to add data in a contact list column. I have tried different formats without luck: only email only name First name, last name, email { email: emailAddress, name: name} I get the following error The value…
-
Is there a way to create a 'collapse section' on a Dashboard?
I'd like to truncate the Dashboard view for my users so that they can select what they want to see by Section Content (eg Project Progress, Project Resource Links, News/Updates etc.), instead of everything being available as a huge data dump a mile long. Is there a functionality to expand/collapse sections on dashboards…
-
Linking an Excel cell to Smartsheet a cell
Dears, I would like to collect status updates from test scripts created and used in Excel and present it in Smartsheet. All test scripts in Excel have one cell indicating the percentage completion level of the test script. Objective is to link that one cell to Smartsheet sheet where I present the list of all test scripts…
-
Pinpoint locations to a map
Is there any way to extract an address from a sheet and pin it to a map? I would want to pin several locations to the same map if possible. I was thinking maybe somehow do this in a dashboard?? Thank you, Cheryl
-
Dashboard Line Chart - Automatically Update
I have a Dashboard created with a Line Chart in place that plots simple data points 'as of' a certain date. I have a Data Shuttle that updates the source sheet each Friday with a new data point. Is there a way to get the Line Chart to automatically recognize that a new row / data point was added to the source sheet?…
-
Sumif column name contains "Tax"
Hi All, I'm using smartsheets to track scores from daily quizzes taken by members over several teams. The end goal is that we want to compare the total scores from each team in a dashboard, so I'm trying to use the sheet summary to calculate the totals. Basically, each column on the sheet has one employee's name and the…
-
Sticker for ENGAGE 2022!
I wanted to showcase the sticker I created for ENGAGE 2022!
-
Data Shuttle Kicked off by Power Automate Flow
I am using a Power Automate Flow to create an .xlsx file and then run an Office Script on it. This is done within 1 flow in Power Automate. The file is saved to One Drive. Currently I have a Data Shuttle that I run manually to take the updated file and load to Smartsheet. Is there a way to use Power Automate to run the…
-
Dashboard - how to change Metric Widget data source after time of creation
How do i change the data source of a metric widget? You can 'add data' but this adds a new one. In my particular use case we can now copy and paste widgets between dashboards, however this is no way to edit the data, ie use the widget as a template. For me, we have a standard project template, and want a standard dashboard…
