Don't create formulas in column validation on the PrjStatus column, because the formula cannot refer to another column. You can create list validation. Navigate to list settings->Validation settings->create the following formula->save: =IF(PrjStatus="COMPLETE",AND(NOT(ISBLANK(SummaryLink)),NOT(ISBLANK([End Date]))),TRUE)


First, as mentioned in the comments above, you should not assume that ID of the first item is 1, you need a more predictable way to get your item. Second, the set_item method should be called from the variable that holds the reference to the item you retrieved. You code calls listItem.set_Item, but listItem is not a defined object. Finally, the attempt to ...

Only top voted, non community-wiki answers of a minimum length are eligible