ryland-dxdl - profile

ryland-dxdl · Jul 27, 2024

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...

ryland-dxdl · Aug 18, 2023

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...

ryland-dxdl · Mar 31, 2023

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 ...

ryland-dxdl · Jul 28, 2024

An elegant solution that works perfectly, thank you so much!

ryland-dxdl · Aug 21, 2023

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...

ryland-dxdl · Apr 03, 2023

@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!

User Statistics

User Activity

Very simple Concatenate question I just can't figure out

Using linked records to create a list of filenames

Skipping empty fields in a naming formula

Re: Very simple Concatenate question I just can't figure out

Re: Using linked records to create a list of filenames

Re: Skipping empty fields in a naming formula