Forum Discussion
Solved
I want to make a cell equal a value based on the value a type in another cell
Happy new year! I have a list of funders in a column and there are two types of funders: you're either Ontario Health (which is classified as a Fund Type 3 funder) or you're anything else (which we...
=IF([@Funder]="","",IF([@Funder]="Ontario Health","Fund Type 3","Fund Type 2"))
This formula returns the intended result in my example.
=IF([@Funder]="","",IF([@Funder]="Ontario Health","Fund Type 3","Fund Type 2"))
This formula returns the intended result in my example.
Thank you so much! I really appreciate the quick reply, you're the best.