Skip to main content
SharePoint

Return to Question

More appropriate and meaningful title
Link
edit approved May 17, 2019 at 6:46
James Randal
edit approved May 17, 2019 at 6:46
James Randal
  • 1.3k
  • 2
  • 10
  • 23

Calculated Column Formula - Nested IF(ISBLANK [TEXTColumn2] then show [TEXTCOLUMN1] if [TEXTColumn3] Is blank then show [TEXTColumn2) and so on Statements

Source Link
Sharepointisawesome
Sharepointisawesome
  • 1

IF(ISBLANK [TEXTColumn2] then show [TEXTCOLUMN1] if [TEXTColumn3] Is blank then show [TEXTColumn2) and so on

Im new to formulas,

My issue is i want to display the current location of said item and keep the old locations so for now i have three columns Location1 Location2 and Location3 and i want to have a calculated column called "current location" showing whichever is the latest location,

for example if column2 is blank then show column 1 and if column 3 is blank then show column 2.