I would like to automatically populate the Email column for an item based on a status change of another column. Is this possible?
I will then use email integration to email these people based on other status changes. These people are not Monday users.
I have a status column with options A, B, and C.
When I change the status to A, I want the email column to automatically be populated with the email Joe_A@email.com. Change to status B, the email column will change to Joe_B@email.com, etc. Currently if the status is changed, and I want the correct email shown, I have to manually type (or copy and paste) the new email address into the email column.