Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Formula

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

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],"")))))

Share: 

 

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
language?

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




Tagged: