Autofill based on the new entry in another sheet

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?

Find more posts tagged with

Sales

Sheets

Formulas

Services

Support

Cell linking

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

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…