Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds


  Asked By: Conor    Date: Mar 05    Category: Sharepoint    Views: 1416

I have created a calculated field and need some help.

calculated Field name GateDate, Time, what I am trying to achieve is if BD
Status = "Qualified Gate 1" and Gate2 Rvw has a date then Gate2 Rvw, ""
I am getting a date of 12/26/1899 in some fields and I think I need to somehow
in my formula say if Gate1 Rvw ="","" (the Gate1 Rvw, Gate2 Rvw, Gate3 Rvw,
Gate4 Rvw are date fields)

=IF([BD Status]="","",IF([BD Status]="Qualified Gate 1",[Gate1 Rvw],IF([BD
Status]="Qualified Gate 2",[Gate2 Rvw],IF([BD Status]="Qualified Gate 3",[Gate3
Rvw],IF([BD Status]="Qualified Gate 4",[Gate4 Rvw],"")))))



1 Answer Found

Answer #1    Answered By: Britni Shepard     Answered On: Mar 05

I'd like to help, but I'm not entirely sure what you're after here.
Could you spell out your logic a bit more explicitly in regular-people

Didn't find what you were looking for? Find more on Formula Or get search suggestion and latest updates.