Hi,Am using a formula I've used in bases before, but it's behaving strangely. It's subtracting a day off of the returned value. I have two fields with dates. Only one of the two will ever have a date in it. I want the formula to grab the date fro...
Hi there,I work in the film industry and am trying to create a base to help me track my work.I make graphics for sets. A graphics might be something that hangs on the wall in a set, so it would be in every scene that's shot on that set. Or it might...
Hi,
I use Airtable to track information for film and television production.
I frequently need to sort a list of scenes by scene number, but scene numbers often have letters added to them, which screws up the sorting.
Example list, which I would want ...
Thank you so much @Justin_Barrett ! This is such an elegant solution.
I’m going to try to better understand your formula in the hopes of furthering my own knowledge.
After I saw this I realized that there is a scenario that I had forgot to mention. ...
In theory it could go as far as Z, but i’ve never seen it. If a screenplay needed that many revisions, I’d say it’s back to the drawing board. :grinning:
