The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.
I created a formula field to merge three date fields into one. No record has more than one date, so I wanted them all to be in one place. However, when I used concatenate, the dates are very long, so I’m trying to use DateTime_Format for all three, b...
Hi all,
I am trying to combine text from two fields using Concatenate (and that’s simple enough) but when I try to add a Substitute formula to shorten one field’s text, it doesn’t work. I am new to formulas, and am sure I’m doing something wrong here...
Hi all, I am terrible with formulas, and have spent way too long looking through previous posts and reading up on Replace and Substitute and Find formulas. I have a column with various names for programs. I would like to cut the first 22 characters o...
I’ve scoured the message boards and cannot find a workaround for this. I have a formula to calculate a Due Date in a formula field; however, the filtering options for the formula field is quite unhelpful. I would love the option to filter for due dat...
I’ve read a couple threads on this but didn’t see an answer. When I open a Linked Record, the fields it shows do not directly correspond with any of my actual views from that table. I want to rearrange the fields for the Linked Records, but don’t kno...
Thank you that was perfect, and sorry for the miscommunication. I’m working on numerous tables and troubleshooting (with very little background with formulas). Your help and patience are MUCH appreciated!
augmented:
CONCATENATE({Program Booked},’ / ',{School Name},RIGHT({2021-22 School Program & Membership},LEN({2021-22 School Program & Membership})-22))
Sure! So this is a different table, but similar function to the 2021-22 School Program & Me...
Hi Justin, thanks for this. Context: I am using concatenate to combine the Program Booked and School Name fields, but as you can see in the example, the Program Booked name is quite long (has to be for Salesforce integration purposes) so I’m trying t...
augmented:
CONCATENATE({Program Booked},’ / ',{School Name},RIGHT({2021-22 School Program & Membership},LEN({2021-22 School Program & Membership})-22))
Thanks for your help (again!). Airtable accepted the formula but it didn’t remove the 22 ch...
augmented:
SUBSTITUTE(RIGHT({2021-22 School Program & Membership},LEN({2021-22 School Program & Membership})-22),‘New School’, ‘New/Comprehensive’)
It worked!! Thanks so much - good to know that I need to keep a closer eye on those apostrophes...