Forum Discussion

TerriWells's avatar
TerriWells
Qrew Trainee
6 years ago

Nested IF Statement to Populate Field

I'm trying to determine if a proposal is late.  Below is the formula: If([Proposal Received 2B Alight]<=[PWO Proposal Due Date],"Yes","No") If(ToDays(Today())<[PWO Proposal Due Date])and If(IsNul...
Formulas and functions
AustinK's avatar
AustinK
Qrew Commander
6 years ago
As Mark said you may need to flip the formula around because if the first line "[Proposal Received 2B Alight]<=[PWO Proposal Due Date]" is true it will always be Yes in the box even if the second condition changes. 

Which dates are changing and what are you expecting to happen when it changes?
TerriWells's avatar
TerriWells
Qrew Trainee
6 years ago

Below is what the formula currently looks like:

 

If([Proposal Received 2B Alight]<=[PWO Proposal Due Date],"Yes",

Today()<[PWO Proposal Due Date]and IsNull([Proposal Received 2B Alight]),"Yes","No")

 

I'm seeing two problems:

  1. When the "PWO Proposal Due Date" is originally filled in, the "Proposal Received 2B Alight" field will always be null
    1. So, when that field eventually gets completed, I need to determine if the CR was Late or On Time.
  2. The other issue I have is human error, if they enter a date incorrectly that field will never get updated.

 

If I flip the formula, do you think that might fix the issue?

 

Any suggestions would be helpful.

 

Thanks,

Terri Wells



------Original Message------

As Mark said you may need to flip the formula around because if the first line "[Proposal Received 2B Alight]<=[PWO Proposal Due Date]" is true it will always be Yes in the box even if the second condition changes. 

Which dates are changing and what are you expecting to happen when it changes?