I have two numerical values, A and B, that I am using to create a range field. Here is my current formula:CONCATENATE({A}, "-", {B}). So far so good. The tricky part is that not all of the entries have a B value, in which cases the result will look l...
Hello, I've looked around for an answer to this but haven't found one yet, apologies if I've been looking in the wrong place or the answer is obvious.My airtable has a list of filename prefixes in one field and a corresponding number of files in anot...
I work in a digital archive and I'm using Concatenate to create a unique naming formula based on certain fields in a spreadsheet. However, some items have different naming requirements. What I would like to do is be able to tell this formula to skip ...
Sorry but this is not what I'm looking for. In addition to the name/number matching it's important that it produce the correct number of filenames; a single entry will produce multiple filenames. So for example: Nameitem-01File count3Should produce:F...
@Ben_Young1 Thank you so much! I was able to plug this in and it worked instantly. I am adding more fields to the spreadsheet and formula and everything is still working exactly like I wanted it to. Thanks so much for your assistance!
