I am trying to convert a name in a list to number I have a column with the title Name and it contains multiple name and I want to create a column which will take the name in the name column and change it to number, this formula works =IF(Name="Jhon","2")
if I want to add more names, numbers it wont work for example, my formula is as follows.
=IF(Name ="Jhon","2")
=IF(Name ="Mike","1")
=IF(Name ="Jane","3")
thanks.
question from:
https://stackoverflow.com/questions/65939876/sharepoint-name-to-number 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…