1

I've column "Name = Order Status","Type = Calculated" & Data Type = "Date and Time". I've given this Condition in the formula:- =IF(NOT([PO Date]=0),"ORDERED","NOT ORDERED"). I'm trying to create view for this column but its getting error while create the view "Filter Value is not in a supported date format".

Same error I'm getting for column "Name = Status","Type = Calculated" & Data Type = "Number". I've given this Condition in the formula:- =IF([PO Date]="","",IF(NOT([Balance Qty]=0),"OPEN","CLOSED"))

Please advice. enter image description here

4
  • what are column types?
    – Waqas Sarwar MVP
    Nov 1, 2014 at 6:13
  • I've added the question in details.Please have a look. Nov 1, 2014 at 6:40
  • In [PO Date]="" expression You want to check if column is blank/empty? Nov 1, 2014 at 11:34
  • Yes, Here I'm checking If PO Date entry is blank/empty then "Order Status" = NOT ORDERED and "Status" = nill. OR If PO Date entry is entered (Date) then "Order Status" = ORDERED and "Status" = OPEN/CLOSED Nov 1, 2014 at 11:38

1 Answer 1

1

Check if column is empty with ISBLANK() function:

=IF(ISBLANK([PO Date]),"NOT ORDERED","ORDERED")

I recommend you test your formula in Excel first, because SharePoint uses Excel engine for calculated columns and validation rules. And here nice article about formulas in SharePoint:

http://yalla.itgroove.net/2012/09/20/sharepoint-calculated-column-formulas/

0

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.