Hi Community, i have a single select field with the following options. I want to add up the results from different columns in a formula. To do this, I need to extract the score from the rest. For example, only “2” should be extracted from “2 More the...
Please someone help me to hide #ERROR! - not all my fields have dates insert and in this case ERROR appears IF( AND( {date}, NOW() >= DATEADD({date}, -30, "days") ), "ending time" )thanks a lot
Brand new to Airtable, so forgive me if this is a dumb question. I've shamelessly stolen a formula to calculate start and end dates based off a T- or T+ from a specific event. DATETIME_FORMAT(DATEADD({Calculated End date},{Days Needed to Complete},'...
Hi! Below you'll find two screenshots - one is the template I started with and the other is the base I'd like to implement the reoccuring tasks formula/automation:The OG formula is too long to allow me to copy the entire thing in. This is the templat...
Hi all,I have two tables: Projects and Tasks. Each task has one or more municipalities. What I'd like to do is check if all the municipalities in each task associated with a particular project are the same. I initially thought I could do this with a ...
This should be a simple fix but I'm not seeing it.I'm doing a record search in Make.com using the Airtable Search Record module. See the attached screenshots.I'm trying to filter out records that already exist. But I'm getting the same output regardl...
Hi all - I'm trying to write a simple formula that returns a Yes or a No if the Role Rollup (from People) field contains CROPPS Member anywhere in the list. As you can see, it's only returning Yes if the field equals CROPPS Member, not contains CROPP...
Context:I have two different tables: A User Info table, and an Event Request table. the relevant columns User Start Date, Event Start Date and Event End Date.Current Status:I am calculating the duration of the events in the Event Request table, pulli...
Hello, I have a look up field which displays a value generated from a formula that lives on another base. I am trying to create a formula field that multiplies the value in the look up field by the percentage value in another field that is generated ...
Hi airtable Community, I want to prefill muliple fields in an airtable form. The first fields (Project name) is working well but the second does somehow not. Both are normal text fields..What did i do wrong? Thanks & BestMirko
| User | Count |
|---|---|
| 896 | |
| 833 | |
| 609 | |
| 533 | |
| 353 |
