Question

Add "Like" conditional formatting

  • 15 January 2024
  • 3 replies
  • 54 views
Z
Rank
Badge +4

Hi everyone,

I'm trying to create a format that starts with FEDEX. I tried entering "FEDEX%" in the condition criteria but it didn't work.

 

Wondering if formatting can support other expressions such as "~" and "%"? Thanks

 

 

 

3 replies

Buddhika Kurera
Rank
Userlevel 6
Badge +13

@ZhanHao It seems like only equal and not equal operators are supported currently on Conditional Formatting in overviews therefore it is not possible to use the LIKE operator. Hope this helps !

 

 

--Buddhika Kurera (buku) -- linkedin.com/in/bckurera/
Z
Rank
Badge +4

Hi, 

Noted with thanks!!

 

 

T
Rank
Userlevel 2
Badge +8

Hi @ZhanHao,

 

One way to still achieve this is to first add a read only custom field that selects the first 5 characters of the SVC Incoming AWB column to the page required. Then add this column to the page through the page designer and apply your conditional formatting to this new field. Example custom field below.

 

Regards

 

Telha

Reply


Terms & ConditionsCookie settings