Formula to include verbiage based upon selection
I am working on a sheet in which I need a formula that when a status is selected in one column that additional verbiage would pre-populate another column.
The picture below in the status column, when I select the word "cancelled", I would like the comments column to show the word "event is not going to happen"
I'll need seven of these done so not sure of the most efficient way to get this done. Any help is appreciated.
Help Article Resources
Check out the Formula Handbook template!