If, Then formula for drop down columns
I am trying to create an IF/THEN formula that automatically changes the value of fields in one column drop down if other values are selected in a different column.
Ex. =IF([Sub-Step]@row = "Research", [Support Stage]@row = "Discover")
First row --> what I'd like to see happen (manually typed in)
Second row --> tried using the formula above, but not generating
Support Stage with Sub-Steps listed for each stage.
If Sub-Step selected equals Research or Support Requested --> Support Stage = Discover
If Sub-Step selected equals Scope the Need, Conduct Assessment, Draft Proposal --> Support Stage = Plan
If Sub-Step selected equals Prepare, Train, Facilitate, Advise and Coach --> Support Stage = Execute
Help Article Resources
Check out the Formula Handbook template!