Hello. I need to add and subtract items that are not numbers nor dates. How can I do it?
To illustrate it, I have changing groups of people working on projects, so I have a first column for people originally assigned, then a second for people who lef...
Hello everyone. I am trying to build a somewhat complex base. I thought I had figured it all out, but I can’t get the last part together, so I would like some help please.
First, I have (1) projects. Projects are created by (2) acts, which assign (3)...
I know. But I thought that, since Airtable support has already been mentioned and the big is real, AT staff would be actively participating in this thread.
Naive me?
Elias_Gomez_Sainz:
The only way to get it to work is summing with a 0 : DATEADD(Date, Lookup + 0, 'days') . Note the + 0 .
Until the bug is solved, that should be stated in the help articles themselves! That info shouldn’t be here and here alo...
I know. I am suggesting precisely that: that what we discussed above is considered, so that we have formulas that perform operations with the existing elements in given set.
@Jeremy_Oglesby, does New Formula Field Functions contain anything like what we talked about in here yet?
In short: a way to perform basic operations with items instead of numbers of text? E.g., taking a set of 3 elements like {A, B, C} and adding D ...
