Automation with Symbols

Hi there,

For a little back story so you understand what I am trying to achieve. We train our shop floor employees and have a three-step process for each station they achieve. The current sheet they are using to track these completions is very manual. Two columns for the dates they were trained on which type and the "completed" column. The third step in the process is manager recommendation.

I am needing the step one and two to automate with the red and yellow symbol when a date is entered. Since the third step is manager recommendation, we figured that portion would have to be manual but would like the other two to be automatic. Also, if there are no dates, would like that to be the grey circle (see attached picture).

Smartsheet Question.png

Let me know if you need more explanation, thank you!

Find more posts tagged with

Accepted answers

All comments

bisaacs

Hey @karawelcome,

So based on your photo, if the first column ("Training") is blank, you want it to be red. But then I'm confused about the difference between yellow and green? When would it be yellow vs green, as the photo provided shows both date columns completed.

karawelcome

Hi there,

Sorry for the confusion, hopefully this clears it up.

Red - only has one training column completed (either training column based off how we do things around here)

Yellow - has two training columns completed without a manager's recommendation to move forward (each employee will eventually move on, so it is just a waiting game on)

Green - has two training columns completed with a manager

's recommendation to move forward (we figure this portion will have to be manual)

Grey - If nothing is completed yet

echaika

I'm looking for automations for Symbol columns as well.

Our use: currently, when a row is changed to Status Inactive, we manually have to change the symbol from green to gray. Seems like it would be pretty straightforward to provide the option to perform an automation to change the value to Gray when a cell is manually changed to Inactive.

We need to keep the option to be able to manually change to other colors as well, so making this a formula column does not help us.

Paul Newcome

@karawelcome You can use a nested IF along the lines of

=IF([MNGR Rec.]@row <> "", "Green", IF(AND([4F1 Training]@row <> "", [4F1 Trained]@row <> ""), "Yellow", IF(OR([4F1 Training]@row <> "", [4F1 Trained]@row <> ""), "Red")))

@echaika Since you are using a symbol column and still need manual adjustment, you will need to leverage the API, the premium add-on Bridge, or some other similar third party app.

Chrissy

It doesn't seem like it would be difficult to add the "symbol" style column to the available selections in the automation workflow for "change cell".

PLEASE ACCEPT THIS IS A REQUEST TO DO JUST THAT. The market needs it, your customers need it. We shouldn't have to know advanced complex formula writing or work with the unintuitive premium bridge addon, to add a column selection option to a templated automation that's already built.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.