The Community will be undergoing maintenance on Friday January 10 at 2:00pm - Saturday January 11 at 2:00pm EST, and will be "read-only." For assistance during this time, please visit our Help Center.
Hello,I have a table that is synced with transactions from my bank account, but I need help with extracting data from a JSON string stored in the Notes (Long text) field.An example of the JSON looks like this: { "transactionId": "2022142460021", "end...
Hey everybody,I am trying to match 2 columns to see if a name from column 2 appears in column 1 (list of names). The answer I need is simply true or false.Column 1 is a lookup field with a name.Example: “Smith, Jack”.And column 2 is a list of names. ...
Hi Airtable Community, The problem is to check in Airtable whether a value in a column (e.g. column 2) occurs **for the first time** or whether it is a duplicate. If the value is the **first occurrence**, a value from another column (e.g. column 4) ...
I've tried to work my way around this problem several ways and I can't seem to figure it out... I have a nested IF statement that uses a value from a text lookup field that just doesn't want to play nice. Essentially, I have a formula title for a rec...
If my event is September 2, 2025 (aka "program start date"), it would be in Quarter 3, 2025. But I need to list that commission would be paid the following quarter (aka "quarter earned", so Q4, 2025. Fiscal year runs Jan - Dec like the calendar.I cur...
Hi again,Is there a way for you to have data from a field "written" to that field and fixed for those changes elsewhere will not affect the result in this field in the future?An example of this might be;A fee in one table is designed to be updated in...
Hello everyone!I need help with a formula that computes two fields as {field 1}/{field 2}.However, the base is new for my team, and we're working to input backdated data, so some records that use these fields are 0 (zero), at the moment. The formula ...
Trying to figure out how to do a search to see if a number falls within 2 fields.For example a field with Start year and a field with End year. Lets say on one record my start year was 1978 and my end year was 1986. I would like to do a search for ...
I have a few currency fields that I am adding up in a simple formula field. I am then trying to display the output of that formula field within a text string I am building with another formula. However, I’m getting some strange decimals when showing ...
I need to calculate different due dates for tasks based on Workday instead of dateadd. Here is my original formula: SWITCH( Task, 'Email for photo, new hire survey, and short bio of new hire', DATEADD({Hire Date}, -7, 'days'), 'Assign desk space f...
| User | Count |
|---|---|
| 906 | |
| 836 | |
| 611 | |
| 551 | |
| 381 |
