How to create a conditional column that only shows when another column contains a certain string

[clobrien]

Hello,

What I'm trying to do is simple. In microsoft lists, I just want a column to show only if another column (which is a text column) contains the string 'SCAR'.

I don't want the conditional column to show if the other column EQUALS 'SCAR,' only if it CONTAINS this string. Is lists capable of doing this?

I think for equals the formula would look something like this: =if([$SORT #] == 'SCAR', 'true', 'false') where SORT # is the column that would contain the string.

So I tried entering =if(contains([$SORT # ], 'SCAR', 'true', 'false'), but it tells me this is not valid.

I've been searching for how to do this and can't find anything so any help would be greatly appreciated!

Maybe lists is limited to the options on their menu here, but it seems like this should be possible: https://learn.microsoft.com/en-us/sharepoint/dev/declarative-customization/list-form-conditional-sho....

(I posted this already, but it was marked as spam and I can't find. Trying again.)

[lbendlin]

It was likely marked as spam because this here is the Power BI/Fabric forum, not the SharePoint forum.  Maybe try over there?