Formulas | Airtable Community

Resolved! पेटीएम कस्टमर केयर नंबर

पेटीएम मॉल से संबंधित समस्याओं के संबंध में ग्राहक सेवा से संपर्क करने के लिए 1800// 8127-80-2259,पर कॉल करें।

19 Views
1 replies
1 kudos

Formula and Linked?

Is there any way to use formulas and linked at the same time? I want a column to add data from the columns A + B + C to = ABC and then have ABC show up on a different tab. Is that possible?

44 Views
1 replies
0 kudos

How can I assign one expense between various business units?

Hey there! I am trying to allocate monthly expenses across our business units (BUs) based on pre determined splitting criteria, some of those criteria change month over month, such as the percentage of revenue each business unit is producing. What I...

48 Views
1 replies
0 kudos

Airtable Rollup Field Bug Report

DescriptionThere appears to be an issue with Rollup Fields when used in conjunction with Linking Records and date columns. The problem occurs when the Rollup formula becomes more complex.How to ReproduceCreate a Rollup Field that references a date fi...

71 Views
1 replies
0 kudos

Struggling with a date / time calculation...

Hello, I am trying to get this to work but all I get so far is a massive headache haha Context : organizing automatic reminders to clients we're meeting at a trade show. On the day of the meeting, I want to send a reminder to the invitee at 8:00 loca...

51 Views
0 replies
0 kudos

Field formula of items not selected in multi select

I researched older posts and found similar topics such as this, but nothing solved that answers this particular question....I want to create a field with a formula that lists any items not selected. An applicant has to acknowledge acceptance of the ...

99 Views
1 replies
0 kudos

Resolved! Is there a better reference for formula keywords?

Being new to airtable and not wanting to pollute the forums with silly questions I can look up myself, I've been trying to go to the online help to solve my own questions. Unless I'm missing it, most of what they provide is an organized set of artic...

151 Views
3 replies
0 kudos

Resolved! How to update a count based on data from another record

Can someone give me some advice on how to update the yellow columns as shown in the example below?I have a fillout form that the approvers can update the approval status of the applicant. On saving and the record gets updated, I'd like the counts upd...

167 Views
4 replies
0 kudos

Lack of Conditional Sum Functionality in Airtable - And Transitivity in realtions!

Hi Airtable Community,I’m currently managing a database where payments are recorded in a “Payments” table, attendance is tracked in a “Attendance” table, and student information is kept in a “Students” table, all to maintain good data normalization. ...

81 Views
1 replies
0 kudos

Resolved! Help with SUBSTITUTE() formula

i'm trying to make a formula to pull out the last name from a field that sometimes has full names in it & sometimes does not. i found this formula in a very helpful Airtable blog:TRIM(MID(SUBSTITUTE(Employer," ",REPT(" ",LEN(Employer))), (3-1)*LEN(Em...

132 Views
3 replies
0 kudos