Automation Question

Ashley.Lowe
Ashley.Lowe ✭✭
in Smartsheet Basics

Hello,

I am new to smartsheets and I'm trying to use the automation tool to auto-populate some of the information on my sheet so it doesn't have to be filled in manually but it doesn't seem to want to work.

I have an interview tracker and what I want to do is if I select "No Show" under the attendance column that it auto-populates status, conditional offer, assessment, assessment results and wage. Below is what I want it to look like when attendance is marked as no show.

image.png

This is the automation flow that I've created but it doesn't seem to want to work.

Am I missing something?

image.png

Any help would be greatly appreciated!!

· Share on FacebookShare on Twitter

Best Answer

  • Will.Parente
    Will.Parente ✭✭✭✭✭
    Answer ✓

    Ashley, you have perplexed me completely! I have no idea how that happened!


    Attempt two: can you update your trigger into "When Rows Are Changed"

    image.png

    Then, delete all of these erroneous rows and hit save.

    Finally, add "No Show" into like three rows. Save your sheet, and reload (automation takes a second to run completely).

    Is your "Attendance" column set up as a dropdown or as a text?

    · Share on FacebookShare on Twitter

Answers

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video