- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 27, 2025 02:32 PM
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)}, "", "*")
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 27, 2025 03:10 PM
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)}, "*")
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 27, 2025 03:10 PM
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)}, "*")
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 28, 2025 06:20 AM
Aah - thank you so much! Love this message board and really appreciate your response!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 28, 2025 06:29 AM
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!
