7

Hi all,

 

Trying to build 2 spreadsheets that need to communicate with each other at this level:

One of them (first) will have the raw material code, name, supplier, last date of testing, risk rating, test required, etc.

The other (second) spreadsheet will be a record of materials booked in.

Will it

2

Setting up an alert system that sends out notifications when a form has been completed.

To streamline the process I would like to use a field from the form in the email title to differentiate between the emails rather than a range of emails with the same title.

Is that possible and if so, how?