Row Copying Issue


I have a sheet, and in it there's a VLOOKUP to another sheet. I set a Copy Row Automation so that when the vlookup cell is filled, it should Copy the Row.

I setup the Wrokflow like this:

  • Trigger: When a Row is Changed
  • When: <Field> Changes to Any Value
  • Run Workflow When Triggered

So, everything pulled into the sheet correctly via the VLOOKUP, but the Automation didn't trigger. I manually made an update to that field (the vlookup field it was pulling back was wrong), and THEN it triggered it to Copy the Row.

Any thoughts on a different way to set this up or what I did wrong? I thought about changing the Trigger to: When Rows is Added or Changed, but that shouldn't matter - I don't think that'll fix it. The only thing I can think of is maybe doing it on Modified Date, with the other field as a Condition??

As always, any help is greatly appreciated.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!