IF Column Formula with Drop Down options
We are trying to create a formula that will recognize a service line type and auto populate the corresponding division in another column, but only for one unique circumstance. Only our Critical Care service lines also need to be Critical Care region.
Below is the formula I tried, but when I make it a column formula, anything that is not Critical care loses the assigned region. Is there a 'IF false' option that would leave the existing or added data in these cells?
=IF([Service Line]@row = "Critical Care", "Critical Care")
What it should do
What what happens with in a column formula
Help Article Resources
Check out the Formula Handbook template!