Copy To Another Sheet

Please help!

I was curious if there is a formula that would copy a row to another sheet, only if a certain column meets the criteria.

I created two sheets that are exactly the same, but one is named Overtime and the other is Branch Visit. If the Branch Visit column states 'yes' on the Overtime sheet, can that entire row then copy that same info to the Branch Visit sheet?

Thank you in advance your assistance!

Overtime Ex.jpg


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!