Data transfer from one sheet to another once condition met

Ali Darzaman
Ali Darzaman ✭✭
edited 04/06/22 in Formulas and Functions

How information in some columns in Sheet A can be transferred to Sheet B once a specified condition in a specific column in Sheet A has been met? Is there any formula I can use? I used Index(Collect ...), but it doesn't do what I am looking for.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!