Autofill based on the new entry in another sheet

Andro ✭✭
edited 12/09/19 in Formulas and Functions

I run constantly to the same problem and decided to shout out for help. Basically my problem can be defined as cross sheets conditional autofill.

My case: Sheet 1 (offers) - sales people add data about new offers with the web form (that's OK)

Sheet 2 (orders) - I need to bring data from the sheet 1, if offer's status is "ordered". (that's a problem).

Is this type of problem possible to solve with the Smartsheet?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!