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!!