Forum Discussion
Solved
Add custom column based on multiple status columns
Hello, I have a data table with multiple status fields, I want to create a custom column based on the values of these fields. Here is a sample of what my data looks like: Candidate Stage ...
do you want to find the latest status or stage name?
Column = if(ISBLANK(Sheet17[Stage 4]),if(ISBLANK('Sheet17'[Stage 3]),if(ISBLANK(Sheet17[Stage 2]),Sheet17[Stage 1],Sheet17[Stage 2]),Sheet17[Stage 3]),Sheet17[Stage 4]) Column2 = if(ISBLANK(Sheet17[Stage 4]),if(ISBLANK('Sheet17'[Stage 3]),if(ISBLANK(Sheet17[Stage 2]),"stage1","stage2"),"stage3"),"stage4")
do you want to find the latest status or stage name?
Column = if(ISBLANK(Sheet17[Stage 4]),if(ISBLANK('Sheet17'[Stage 3]),if(ISBLANK(Sheet17[Stage 2]),Sheet17[Stage 1],Sheet17[Stage 2]),Sheet17[Stage 3]),Sheet17[Stage 4])
Column2 = if(ISBLANK(Sheet17[Stage 4]),if(ISBLANK('Sheet17'[Stage 3]),if(ISBLANK(Sheet17[Stage 2]),"stage1","stage2"),"stage3"),"stage4")