Skip to main content

I have a field that sometimes has a mentor's name in it, and other times (usually) is empty.

I am showing that field in a timeline - which is fine when there's a name, but otherwise it shows up as "(empty)" which is annoying

I want to create a formula field that shows the value when there is a value (a name), but shows something innocuous - like an asterisk - when it's empty.

I feel like this is an IF statement - but the value of the field is different all the time - Joe Schmoe, Jane Doe, etc.


IF
({Mentor (from Link to Forms)}, "", "*")
 
is what I'm trying now, but it's giving me a blank where I want the name. What is formula for "the value of the field?"
 
Thanks for your help!

Hey @Lisa_Wetherby!

You are almost there! The formula you are looking for is actually:

IF({Mentor (from Link to Forms)},{Mentor (from Link to Forms)}, "*")

Mike, Consultant @ Automatic Nation


Aah - thank you so much! Love this message board and really appreciate your response!


Glad to hear that @Lisa_Wetherby!!

Feel free to schedule a call using this link if you have any other Airtable related questions or ideas!

Mike, Consultant @ Automatic Nation


Reply