Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Action : change cell value

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

Best Answer

  • ✭✭✭✭✭✭
    Answer ✓

    @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

Answers

  • 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

    Davide Musmeci, PhD

    Project Management Professional

    www.digitalflows.eu

  • 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

  • ✭✭✭✭✭✭
    Answer ✓

    @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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions