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), “
”, “
”)
name,guid,file
dog,dog,dog.jpg
cat,cat,bird.jpg
The first row would return ; the second should give .