Automation Question


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.

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

Am I missing something?

Any help would be greatly appreciated!!

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"

    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?