Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Trying to Figure Out Scripts
Hey all! I must preface this by specifying that I am a complete newb when it comes to Smartsheet. I know the very absolutely basics, but am now trying to learn more about it.
The issue I'm trying to figure out is keeping track of multiple packages I send out a week. I wanted to see if there's a way to write a script where it would update the status in a cell when the package status changes. Would this be possible? From what I've seen so far, this can be possible in Excel with a script, but I use Smartsheet more.
Answers
-
You can use an automation to do this. So, setup the automation to trigger when the Package Status changes. Use conditions to split up the automation paths for your different Package Statuses if needed.
For each path, add an action to Change Cell Value. Pick Status cell and pick the value that you want it to update to.
Here's more detail on setting up automations:
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 208 Use Cases
- 517 Announcements
- 5.6K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 84 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
