tags:

views:

283

answers:

1

Hello!

I added a new calculated column A to a sharepoint list. This column A should be updated if the value of another column B changes and if column A is still empty! I struggle in implementing the "if column A is still empty" part of the formula.

Here is my formula:

=IF([Issue Status]="Active",Today)

Additionally I added a column called "Today" and deleted it again after entering the formula. That works!

Does anybody know who to implement the "still empty" part?

Thanks Daniel

+1  A: 

You would use the ISBLANK() function. Tip of the hat to Primo over at ObjectMix.

Some common functions available are listed on the Office help site that may also help.

Essentially you'll end up with a formula along the lines of:

=IF(OR([Issue Stats]="Active",ISBLANK([B])), "true value", "false value")

Mark