SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a list where I want a 'Status' column to show different values based on entries from 3 other columns from the same list item. These 3 columns are 2 choice columns 'Reviewed by' and 'Followed up by' both populated from a group and lastly 'Archived' which is a Yes/No choice. I want the 'Status' to show 'Review' if there is a value in 'Reviewed by' column, but if there is a value in 'Followed up by' the 'Status' should be 'Follow up' and if the 'Archived' column is 'Yes' the 'Status' should then be 'Archived'. When the item is created 'Status' would be set to 'New'as a default. I've been thinking how to use the ISBLANK formula but can't figure out how to nest multiple IFs.

share|improve this question
up vote 3 down vote accepted

To nest IF statements you just put them inside one another like so:

IF(test1, [FieldToShowIfTest1Suceeds], IF(test2,[FieldToShowIfTest2Suceeds], [FieldToShowIfTest2Fails]) )

The 2nd IF in bold will be evaluated only if the first test fails.

So something like..

=IF(NOT(ISBLANK([Reviewed By])),[Reviewed By],IF(NOT(ISBLANK([Followed up by])),[Followed up by], [FieldToShowIfSecondIfFails]))

share|improve this answer
It works! Thankyou for your help Louis. – Marton Denison Feb 7 '12 at 4:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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