Desired Result: An Alert email is sent to the user name specified in the Contact List column when the status on that row equals a certain value.
Example Layout:
Column A is a Contact List drop-down
Column B is a Status drop-down with labels of Planning, Contract Request, Complete
Columns C - Z are various data fields
Example: Status field (Column
is changed from 'Planning' to 'Contract Request'. When the sheet is saved any rows with the status of 'Contract Request' will have an alert sent to the user name in the Contact List field (Column A). If there is no user name in Column A then nothing is emailed.
At this time Alerts seem to be pretty close to what we need but not completely there. You can call out a column but not a value for that column which I what we seem to need.
Anyone have any ideas? We are open to ideas on this one. Maybe something related to cell linking or conditional formatting?