0

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 at 14:36
0

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.

Finally, Danny Engelman's calculated columns page is worth bookmarking.

0

You could use this formula:

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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