I have a sharepoint list with multiple calculated fields. I am looking to roll the fields into one by choosing a final status. There are 6 columns. I want the formula to look at all six columns and display the value of the ONE column that is NOT blank.
I'm sure this is easier than I am thinking, any help would be greatly appreciated.
Thanks in Advance!