Can multiple formulas be assigned to a field. I have a filed that determines the days between Estimated completion and Date started, Wanted to have the Field change color if late, if not late, or have a label stating “No assigned Date” if no dates we...
Hi I am new to Airtables and trying to create a formula that uses data from another table, is this possible?
Hello, I have a table of courses linked to a table of course runs. The course run table has many records connected to one course. The course runs table has multiple course run dates linked to a single course. I would like to calculate the next upcomi...
I’m wondering if there is (or could be) a way to change a formula for a particular cell or row? For example: I use airtable to track gigs for artists I represent. Typically, we take x% for every gig. In certain special cases, we may take y%. Is there...
OK, so, strictly speaking not a bug, but certainly an infelicity. :slightly_smiling_face: Maybe someone can step on it next time something else needs fixing in DATETIME_DIFF… For background, see this post in the Support forum. Specifying 'day ' or ...
Is there a programmatic way to count columns? I am aware that COUNTA() exists, but I have to manually input the column names into the formula. Is there a way I can access the names of the columns and count the ones that contain the word “Siege” for e...
I don’t quite understand why I am seeing two different kinds of behavior from very similar ARRAYUNIQUE rollup fields. I am making a database of health issues. One table is Substances (nutrients, herbs, medications, etc), another is Issues (diseases, ...
I’m trying to calculate dates based on two values. I have a formula that works for this: IF({Renewal type} = "Annual", DATETIME_FORMAT(DATEADD({Last register date}, 90, 'days'), "MM/DD/YYYY")) If I try to add another IF statement then it fails: IF({...
Airtable doesn’t seem especially forgiving of formulas doing numerical operations when the original cell contained text. For example, I have a cell describing engine sizes of cars. They’re pasted in like the following: “1498cc”. I’d like to show the ...
Hi, When there is a field with a pure text value “1 + 1”, I would like to dynamically calculate it and put the result in to the other field. For example: | 1 + 1 | 2 | | 2 * 3 | 6 | Thank you.
