I have a formula that displays a new volunteers' mentor on a schedule for staff - basically, if there is anything in the field {Mentor (from Link to Forms)}, show that, or else show * (to prevent the field from showing up (empty) on the schedule. Here’s that formula:
IF({Mentor (from Link to Forms)},{Mentor (from Link to Forms)}, "*")
What’s happening is that this information is pulling through many deployments later - when a Mentor is irrelevant.
I want to change the field so it is dependent on the Experience field - which I hope would make it go away when that field is NOT “This is my first deployment.”
So:
IF(({Experience (from Link to Forms)}, "This is my first deployment",), {Mentor (from Link to Forms)},{Mentor (from Link to Forms)}, "*")
But that is not doing it for me. What am I missing?
Thank you!
~Lisa
