SharePoint Calculated Column - Get Dynamic Column ID

Question

I have a number column called "Team Leader", "Process Lead", "Regional Manager"

I will get Team Leader Name, if "Team Leader" Column is Blank, then Get the Name of "Process Lead", if Both Column is Blank then Get the Name of "Regional Manager"

I also have a calculated column that looks to this column.

=IF(ISBLANK([Team Leader]),"",[Team Leader]),=IF(ISBLANK(["Process Lead]),"",[Process Lead])

This is where I am with my formula which doesn't work. Has anyone achieved this? ?

question from:https://stackoverflow.com/questions/65861601/sharepoint-calculated-column-get-dynamic-column-id

Answer 1

Either of these 2 should help you:

First, result in blank value if Regional Manager is not provided.

IF(ISBLANK([Test column1]),IF(ISBLANK([Test Column2]),IF(ISBLANK([Test Column3]),"",[Test Column3]),[Test Column2]),[Test column1])

Another one:

IF(ISBLANK([Test column1]),IF(ISBLANK([Test Column2]),IF(ISBLANK([Test Column3]),"",[Test Column3]),[Test Column2]),[Test column1])