Best Of
Re: Smartsheet Style: Swag Is the Bag!
I should have posted this a long time ago. Here is my swag! I LOVE it! Unfortunately, I no longer have the hat. It was claimed by my niece who, is obsessed with baseball caps, and really really wanted it. She's a cutie pie so I caved and gave it up.
Thank you Smartsheet!
mcullen
Re: Generate a list of users with access to workspace
Most welcome! Have a good one.
Yvonne Smythe
Smartsheet - Down to the Basics Cheat Sheet
Hello fellow community members!
When I first started using Smartsheet, I struggled—a lot. Even the most basic tasks felt overwhelming. As someone who learns best independently, I started creating a personal cheat sheet to keep track of all the key functions, tips, and tricks I picked up along the way. Over time, it became an invaluable resource, helping me navigate Smartsheet more efficiently.
Now, I want to pay it forward! I’m sharing my cheat sheet with the community in the hopes that it can help others who struggled as I did. Whether you’re just getting started or looking for a handy reference, I hope you find it useful!
Disclaimer: I do not work for Smartsheet, and I am by no means an expert—just someone who has learned through trial and error and wants to help others on their Smartsheet journey.
Enjoy!
mcullen
Re: February Question of the Month - Join the conversation and receive a badge
I love this @Ipshita!
Yvonne Smythe
Re: Update cell via Power Automate
As Georgie mentioned, Power Automate does not have a built-in "Update Row" action for Smartsheet. However, updating a specific cell using the HTTP action method is possible. The attached short video demonstrates this with a demo of the Power Automate workflow.
While updating Smartsheet via Power Automate is achievable, I find it more straightforward to use the Smartsheet API directly with a preferred programming language's SDK, such as the Smartsheet Python SDK. This provides more flexibility and efficiency for updating cells and rows.
For those interested in using the HTTP method in Power Automate, Microsoft provides helpful documentation on HTTP actions here:
🔗 Power Automate HTTP Actions
Hope this helps!
(Note: Perse JSON action is not necessary.)
Freelance Work Wanted~!
Hi there! I’m a Project Manager & Smartsheet Specialist with over 5 years of experience helping teams streamline workflows, build insightful dashboards, and automate tedious tasks. I genuinely love making people’s work easier, more efficient, and more impactful—because when your systems work for you, you can focus on what truly matters.
✅ Custom Dashboards & Reports for real-time insights
✅ Automations to reduce manual work and increase efficiency
✅ Project & Task Management Solutions tailored to your needs
✅ No project is too small—I’m happy to help however I can!
I’m looking for extra work to support my family while doing what I love—helping people succeed.
📩 Send me a message, and let’s build something great together.
Paul Woodward
PJWoodward12@gmail.com
Paul.Woodward
Re: Workapps Permissions and Collaboration
Multiple admins for Workapps would be awesome - highly recommend putting an enhancement request in if it's not already there
Brian_Richardson
Re: Can't create an X-axis on a scatter plot
Here is my solution.
In the sheet, the yellow columns are the original ones and the green columns are the newly added ones
ID : Text number column, prepopulated as much as you want.
Design Hours2. : is a distinct and sorted column of the Design Hours2 column in the yellow zone, with a column formula:=IFERROR(SMALL(DISTINCT(COLLECT([Design Hours2]:[Design Hours2], [Design Hours2]:[Design Hours2], <>"")), ID@row), "")
Scatter Unstarted. : column formula: =IFERROR(INDEX(COLLECT([Scatter Unstarted]:[Scatter Unstarted], [Scatter Unstarted]:[Scatter Unstarted], @cell <> ""), MATCH([Design Hours2.]@row, COLLECT([Design Hours2]:[Design Hours2], [Scatter Unstarted]:[Scatter Unstarted], @cell <> ""), 0)), "")
Scatter In Process. : column formula=IFERROR(INDEX(COLLECT([Scatter In Process]:[Scatter In Process], [Scatter In Process]:[Scatter In Process], @cell <> ""), MATCH([Design Hours2.]@row, COLLECT([Design Hours2]:[Design Hours2], [Scatter In Process]:[Scatter In Process], @cell <> ""), 0)), "")
Scatter Completed. : column formula=IFERROR(INDEX(COLLECT([Scatter Completed]:[Scatter Completed], [Scatter Completed]:[Scatter Completed], @cell <> ""), MATCH([Design Hours2.]@row, COLLECT([Design Hours2]:[Design Hours2], [Scatter Completed]:[Scatter Completed], @cell <> ""), 0)), "")
I hope it helps!
Gia Thinh
Re: February Question of the Month - Join the conversation and receive a badge
I'm not very creative but some ideas I have are badges for community ranks and creating and using templates.
khickman