Action : change cell value

bosen tseng

Hi Community,

I feel like this is simple question, but I can make it happen.

If I want to using change cell value in automation workflows, can I change the cell value by using formula?

Cause I use the formula to change, the result always add ' in front of the formula…(show as the pic below)

Besides, can it make the value show as parent value + children value? Like the pics show

I want to change the cell "to sam" to become "HBD to sam".

Any help would be amazing! Thanks for any reply!!!

Bosen

Find more posts tagged with

Formulas

Automations

Workflows in Smartsheet

Accepted answers

Ray Lindstrom

@bosen tseng,

Unfortunately, you cannot add a formula to Automation workflows.

You can however create an additional column which you can keep hidden if you prefer.

That column can capture the parent and same row data and concatenate them together.

Use this formula, and turn it into a column formula:

=PARENT([Task Name]@row) + " - " + [Task Name]@row

Then you can reference that column for your alerts and/or update requests.

Hope that helps!

BRgds,
-Ray

All comments

David3_DigitalFlows

Hi Bosen,

can you share more information on the main reason why you want to do so with a automation?

What's your final goal, overall?

There might be simpler way to do so.

Best
Davide

bosen tseng

Hi David, thanks for reply!!

I set up a function to send an alert email to task owners and the project manager before the deadline. Instead of displaying the entire sheet, I only show rows that are nearing the deadline. However, some rows don’t display the task name because they are under a parent task. As a result, the email only shows the description(task name is blank), which may confuse the manager about which meeting needs a time confirmation.(like the pics bleow)

Due to this situation, I want to create a function that fills blank cells with the parent task's value or replaces them with 'Parent Task + Current Value' to make the meaning clearer.

That's why I want to change cell values in the automation workflow. However, when I enter the function in the space in workflow, it doesn't run and instead adds a ' at the beginning.

Thanks again for your reply!!

Best

Bosen

Ray Lindstrom

@bosen tseng,

Unfortunately, you cannot add a formula to Automation workflows.

You can however create an additional column which you can keep hidden if you prefer.

That column can capture the parent and same row data and concatenate them together.

Use this formula, and turn it into a column formula:

=PARENT([Task Name]@row) + " - " + [Task Name]@row

Then you can reference that column for your alerts and/or update requests.

Hope that helps!

BRgds,
-Ray

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.