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.

  • So did you get the calculated column to work?
    – Tally
    Jun 7, 2019 at 14:36

2 Answers 2


You could use this formula:

=IF(ISBLANK([Column 2]),[Column 1],IF(ISBLANK([Column 3]),[Column 2]))

Hi SPistotallyawesome,

This post deals with nest IF statements in a calculated column; they are fiddly to begin with.

As Ryan mentions in his answer, download Notepad++ - it's free and it has a cool chameleon icon, what more could you want!

If you need some more examples to study browse through the Calculated Column Tag to see related questions.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.