Skip to main content
Question

Nested IF Statement to Populate Field

  • March 2, 2020
  • 0 replies
  • 117 views

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(IsNull[[Proposal Received 2B Alight]) ,"Yes","No")

 

The first "If" statement works without any issues, but I get the following syntax error on the second "If" statement:

Error:

Column: 0 > There are extra characters beyond the end of the formula.

I'm a new QuickBase user, and any help would be appreciated.



------------------------------
Terri Wells
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
np to help you, but we need to know what logic you want.  To quote the famous Kirk Trachy, "if you can say it we can do it."


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------