-
Gennevieve at Communinty
Gennevieve at the Community booth absolutely crushed it. She was able to show me around to some cool spots and gave me some insider tips!
-
Stumped on an IF formula
I have data in the following fields: Target Sales: Last Week's Sales: I currently have a formula that tells me if Last Week's Sales are less than Target Sales, then return "Yes" or "No" I need to update the formula to tell me if Last Week's Sales are less than Target Sales, are Last Week's Sales below more than 5% of the…
-
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!
