Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Calculated Field Question

  Asked By: Paul    Date: Apr 18    Category: Sharepoint    Views: 5674

Hello,

I need to combine the two statements into one, but I'm having no luck. Any thoughts?

IF([Issue Status] = "Active"

AND

IF([Target Close Date]>[Today's Date], "Yes","No)

If both conditions are true I want a yes otherwise no.

Thanks

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Paul Braskett     Answered On: Apr 19

just got this to work...

=IF(AND([Issue Status]="active",[Todays' Date]>[Target Close Date]),"Yes","No")

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




Tagged: