Any Tips to find archived entry when archive automation set-up?

Am having trouble with Archive Automation. When the automation runs, the row that should move is moved from active sheet, but doesn't show up on Archive sheet. What am I doing wrong?


Answers

  • And the other issue that I have is that all my entries move even when the trigger is not met.

  • Brent Wilson
    Brent Wilson ✭✭✭✭✭

    I have created a Trigger Column with a formula and let the sheet do the logic then you can run the logic when the trigger is set to 1

    Check the sheet name in the move or do you have a filter applied in the Move to sheet? Seriously the time I have spent trying to figure out why my logic is not working only to have a filter applied 😖

    Brent C. Wilson, P.Eng, PMP, Prince2

    Facilityy Professional Services Inc.

    http://www.facilityy.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!