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...
Random suggestion: Global Option SetsWe have many different projects running within our nonprofit. We need to keep them separate, as each project has it’s own data needs.However, there are two drop-downs that are used regularly; Country of Origin and...
Hi guys, I've got a similar query where I need to find out how many Saturdays are in the current month. Needs to be a formula as it's going to be a rolling thing that is linked to a monthly automation.I've gone over this thread a few times, and I can...
Also, even on Enterprise - I've found that even with automations running an action regularly to keep the syncs/base active, the numbers are very frequently out of date. I was hoping to set up a monthly digest type email, but am currently doing it man...
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!
