Formulas
cancel
Showing results for
Did you mean:

## Forum Posts

### using sum values in grouped fields for other formulas

How do I use sum values automatically calculated when grouping fields for other formulas?I have to calculate the sum of values of a grouped field in other formulas. Is it possible? someone told about rollup, but I did not manage to obtain any useful ...

### Can someone tell me what this formula string would look like?

Hi All I would like to know if someone can assist me with create the formula used in the time off id column for this video at the timestamp 2:04 https://www.youtube.com/watch?v=Q-MEmIHCHU4&t=8s

by 4 - Data Explorer
• 211 Views
• 1 replies
• 0 kudos

### Formula for "is subtask" scenario

I have a simple task tracker with a single table containing a list of tasks.  I have a self-linking field to allow for a single level of subtasks.  I primarily use Interface lists to view tasks.  However, I also assign tasks to be completed by varyin...

### Hardest Problem I've Ever Encountered

Okay guys, got a doozie... Basically, in the screenshot I have a table, which is the main table that 99% of things sprout off from. We have customers, who through a webflow form are able to select accessories to add on to their purchase. That gets re...

by 5 - Automation Enthusiast
• 993 Views
• 8 replies
• 0 kudos

### Age Eligibilty

Hi! I am unsure if it is possible to create a formula to make this work for my school, please help!I have a base created to track all applicants. We offer 5 trade classes each held 3 times a year that have a minimum age requirement; age 16yrs and 8mt...

### Calculate the remainder amount of a transaction by subtracting sum of prior partial transactions

We have a database of transactions that is monthly via csv import. This contains information like transaction id, amount, duration.Most transactions are simple one-time occurrences; however, some transactions happen over the span of months.For these ...

by 4 - Data Explorer
• 141 Views
• 0 replies
• 0 kudos

### Check if a date in the current tab falls between the start and end dates of ANY entry in another tab

This might not be possible (especially since our nonprofit is on a free plan) but we have a number of projects that require review by our general counsel before they can finish. We have a tab with the start and end dates of each project. Our General ...

by 5 - Automation Enthusiast
• 614 Views
• 3 replies
• 0 kudos

I have a table linked to itselfA Lookup field type still works fineBut a Count field type always returns the value 1 when in some cases it should be more than 1

### add +100 on each new row

Hey,Something super basic to do in any excel, python script etc. but how to get in in Airtable?I want to create some kind of ID for each customer. First customer has number 900100, and each new one (this is a child table) should get the number +100, ...

by 5 - Automation Enthusiast
• 379 Views
• 4 replies
• 1 kudos

### Limit data submission by user

I would like to limit the number of rows created in a table. I am planning to have a limited data entry period with 100 users where each user can only put in 10 rows of data. How would I achieve this with Airtable?

by 5 - Automation Enthusiast
• 576 Views
• 4 replies
• 1 kudos