WHAT AM I DOING WRONG HERE?? https://drive.g...

(Sarvesh Mudkavi) #1

WHAT AM I DOING WRONG HERE??

https://drive.google.com/open?id=12zX4Ptufubggl__gvSE1fWBtKX5gtsXn

(Suvrutt Gurjar) #2

Hi

@Sarvesh_Mudkavi,Is your column [Stockiest Name] an

Enumlist, kind of column? I tested that function INITIALS works on column types Name, Text and Email but not on Enumlist, Numbers and dates etc for obvious reasons.There may be more valid and invalid types but you will get the idea.

(Sarvesh Mudkavi) #3

Hello @Suvrutt_Gurjar it is REF column

(Suvrutt Gurjar) #4

Hi @Sarvesh_Mudkavi

My quick testing shows that if it is a ref type column referencing a number type key column with stockiest name as label in parent table, then it does not work. But if you are referencing a name

type column as key from parent table then it works.

May be you wish to get the stockiest name from your parent table into child table with dereferencing formula and then use it in initials.

(Sarvesh Mudkavi) #5

@Suvrutt_Gurjar Thanks, will check it out