Move Row: Will not move if condition has a dropdown list
I am trying to automate copying a row from master sheet to child sheet.
The trigger is when a row is changed to "New" it should copy to the child sheet. This is one of 4 choices in the column. It is a column with dropdowns.
When creating the automation, I am not able to choose "new" as the thing it changes to in order to kick off the automation. Columns that are just text function correctly, but if it is a dropdown list, it is not working.