Referencing file name in the formula column

Platform discussions Special workflows & use cases
1

Is there a way to write a formula that queries the name of a file in the file column?

Here’s what I’m trying to do:

IF(AND({Name} = {guid},SEARCH({Name}, {File}, 1) > 0), “:green_circle:”, “:red_circle:”)

name,guid,file
dog,dog,dog.jpg
cat,cat,bird.jpg

The first row would return :green_circle:; the second should give :red_circle:.

1 Like
2

Hi Elliot. Did you ever get this to work?

1 Like
3

I don’t think I did. I could query basic text columns but not file names within a file column. So I just had to get into the habit of manually checking file names before uploading them! Not ideal.