Change column cells based on different column input
I'm trying to create a formula that will change a cell in a particular column if the value in another column is Yes or No.
For example, I have a column of statuses and another column confirming if it's an issue or not. If the issue column says Yes, I want the cell in that row in the status column to say Assigned.
Been looking at the formulas and functions and can't seem to get it right. Any help would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!