0

I am trying to search in the files names for HC, so I can have a Yes / No output to be able to filter on it, since MS does not have a does not contain option in filter.

Names of the File:

SLS802 2021 Price Increase Stick Report by Cust Location - Prod Family - HC - Canada_03162021.xlsx
SLS802 2021 Price Increase Stick Report by Cust Location - Prod Family - HC - Canada_03162021.pdf

When I try to use the formula: =ISNUMBER(FIND("HC",Name)) it gives me error messages of the column does not exist.

If I use the formula: =ISNUMBER(FIND("HC",[Title]))

it gives me the output of No

I have also tried:

=IF(ISNUMBER(FIND("HC",[Title])), "OK", "Not OK")

it gives me the output of Not OK, so its saying that everything is false

I am not sure how to have it search and be true

Picture of the document library below

enter image description here

Also picture of the document library:

enter image description here

1 Answer 1

0

When you create a calculated column formula, [Name] column doesn't show up as an option in the "Insert Column" list. So, it's not supported to be used in Calculated column formulas.

You could use [Title] column. However, your [Title] column is empty as you haven't populated it with any data. I'm afraid your option here is to use Workflows or Power Automate to accomplish this task.

More info on FIND and SEARCH functions: here and here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.