Project_NP_LS - profile

Project_NP_LS · Jul 08, 2024

Hello AT Community, I am looking for a formula that capitalises the first letter of every word before the " |" in a string. 3 examples belowEXAMPLE 1The output for "ARCHITECT | Tom Jerry” to be ArchitectEXAMPLE 2The output for "BUILDING AUTHORITY OF...

Project_NP_LS · Mar 03, 2024

Hello AT Community, I am trying to write a formula that returns the number of years and days in between two dates. So for example, assuming {DoB} is 18 FEB 1994, DATETIME_DIFF(TODAY(),DoB,'years'),"y ") returns 30 which is correct.I would also like t...

Project_NP_LS · May 10, 2023

Afternoon,I am trying to find a way to create a series of symbols (see attached) that I can use in my base. Unfortunately, these are not standard symbols that one could get as an emoji for example. These are all cricket scoring symbols that I am tryi...

Project_NP_LS · Jun 19, 2022

I have 10 fields in a table, and some contain numbers and the others either a letter or a symbol, in the same table I would like to have another field that sums up the values of the numbers only in that record. Is there a simple way/formula to do thi...

Project_NP_LS · Apr 06, 2021

Dear AT Community, I have just started using the Page Designer Block/App but when I click on the colour of a text in order to try and change it, no colour palette comes up. Has anyone else experienced this? Thanks in advance Ladi

Project_NP_LS · Jul 12, 2024

Thank you very much, this is absolutely perfect. Shame Airtable don’t have a PROPER function like in excel, but I guess we can’t have everything. Thanks again. 

Project_NP_LS · Jul 11, 2024

Hello there, Apologies for the delayed/late reply. This is perfect and helped me get to where I wanted. Thank you very much indeed. I actually had to wrapped your formula in a this one, LEFT(Your Regex Formula, FIND("|", {Name}) - 1) order to get the...

Project_NP_LS · Mar 03, 2024

Hi Dan, Thanks for your reply. In the meantime, this is the formula that I am using IF(DoB,CONCATENATE(DATETIME_DIFF(TODAY(), DoB, 'years'),"y ", DATETIME_DIFF(TODAY(), DATEADD(DoB, DATETIME_DIFF(TODAY(), DoB, 'years'), 'years'), 'days'),"d")) STEP 1...

Project_NP_LS · Jun 20, 2022

Thank you very much. One final formula question, if I have 20.3 as a number in a field, how can I extract the 20 and then the 0.3? It’s a weird question I know but I this is what I am looking to do for a specific calculation requirement for cricket

Project_NP_LS · Jun 19, 2022

Hello Kamille, Another question, here is a simple base Airtable - Grid view I would like to create 3 separate fields, one that counts up the number of DOTS in the 6 fields, one that counts the number of Ws in the 6 fields and one that counts the numb...

User Statistics

User Activity

AIRTABLE'S ANSWER TO EXCEL'S PROPER FUNCTION

Calculate difference between 2 dates and return answer in Years and Days

Creating Symbols

Formula - sum of fields

Page designer block/app

Re: AIRTABLE'S ANSWER TO EXCEL'S PROPER FUNCTION

Re: AIRTABLE'S ANSWER TO EXCEL'S PROPER FUNCTION

Re: Calculate difference between 2 dates and return answer in Years and Days

Re: Formula - sum of fields

Re: Formula - sum of fields