Project_NP_LS - profile

Project_NP_LS · Aug 13, 2024

Hello,I have 3 tables which are linked to each other Customers Invoices https://airtable.com/app0jw4sAdW5VRy68/shrRhehmziVBIfiAG Budget vs. Costs https://airtable.com/app0jw4sAdW5VRy68/shrTYer8pWxDAuat6 The Invoices table is my catalyst. I have creat...

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 · Aug 16, 2024

Hello Adam, I have actually since found a solution, using the Record ID. Thank you all the same for taking the time to look at and consider my question.

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

User Statistics

User Activity

Linked Record Automation

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

Re: Linked Record Automation

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