Trying to Figure Out Scripts

Nizhalgal

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.

Brian_Richardson

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:

https://help.smartsheet.com/learning-track/level-2-intermediate-users/automation