Hi
I have two columns I want to create a new column which tells me "Won" if status reason is Won but if not gives me the current sales stage.
What I want this column of data to look like is below
Current Sales Stage (Q)---Status Reason (R)--- COMBINED COLUMN
Prospect---Lost --- Prospect
Prospect---Won--- Won
Prospect---In Progress---- Prospect
Gate 4 ---Cancelled-Customer --- Gate 4
Prospect---Won --- Won
Prospect---Won--- Won
Prospect---Lost ---- Prospect
.....
This is the formula I have tried and it is not working...
=IFS(Q2="Prospect","Prospect",Q2="Gate 0","Gate 0",Q2="Gate 1","Gate 1",Q2="Gate 2","Gate 2",Q2="Gate 3","Gate 3",Q2="Gate 4","Gate 4",Q2="Preferred Bidder","Preferred Bidder",R2="Won","Won")
Any ideas?
Bookmarks