So, I have some columns in one of my bases that are complex formulas working something out based on year. These particular formulas are necessary as there is no quick workaround via rollups etc., it's not pretty - and there is something better involv...
Question as in the title I've been doing a lot of work fixing structural errors, and the Manage Fields has been super helpful. However, I did notice it didn't update in real time.Not an urgent issue, just out of curiosity: does anyone know when it r...
Hi everyone,
Hitting a bit of a wall with some formulas and wondering if anyone has a more elegant solution to this…
I’m working on a new base that records start and end dates of some work that we do. I then have a datetimediff that calculates the nu...
Hi guys,
I’m having a slight issue with a synced table. It has added 6 blank records that don’t exist on the source table and that weren’t there after the destination table was created/before the sync.
There’s definitely nothing to delete (first thou...
Hi All,
I use the API to pull our data into Excel for automated reporting, and it does the job quite nicely :slightly_smiling_face:
However, I’ve added a new column to collect a bit more information, but that column doesn’t seem to be available to ...
So weird! Are you able to paste your modified formula please?I think I may just have to chalk this up to a random error... motivation to get the other solution up and running pronto!
The formula columns are using the formula I mentioned in this post here: Solved: Conditional DATETIMEDIFF - Airtable CommunityIn terms of formatting, they all show this:The available columns to select show all of the previous four years except the mo...
Just adding our use case and +1. We have bases split by project/department, with syncs set up where they interact, so the team only access the bases/data they need. But our comms team regularly use data points from all departments. An interface that ...
Think I may have found a solution to this that addresses the issue. Leaving some working here in case it comes in handy for anybody else.
The best solution seems to be having a column per year. The below formula is based on the thinking that every pr...