Autofill based on the new entry in another sheet

Andro

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?

Shaine Greenwood

Hi Andro,

I'd recommend creating IF statements that return one value in sheet 2 based off the value from sheet 1. More information on cross sheet formulas can be found here: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets

If you're new to formulas in Smartsheet, I'd also recommend checking out our article on how to build Smartsheet formulas: https://help.smartsheet.com/articles/2476171-create-and-edit-formulas-in-smartsheet