Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Name when Name, * when (empty)

Solved
Jump to Solution
192 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Lisa_Wetherby
6 - Interface Innovator
6 - Interface Innovator

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!
1 Solution

Accepted Solutions
Mike_AutomaticN
10 - Mercury
10 - Mercury

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

See Solution in Thread

3 Replies 3
Mike_AutomaticN
10 - Mercury
10 - Mercury

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

Lisa_Wetherby
6 - Interface Innovator
6 - Interface Innovator

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

Mike_AutomaticN
10 - Mercury
10 - Mercury

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