Skip to main content
Question

Help With Formula

  • September 9, 2019
  • 0 replies
  • 12 views
If(
//If the target date is greater than completion date and the Completion date is equal to ""
[Status] = "Open" and
[Target Date] < Today()and
IsNull([Completion Date]),
// set the Status to Past Due
"Past Due",

//Otherwise
null)

If the condition is not met, there appears to be no issues.  If the condition is met, the error is:

Unable to save changes
Custom data rule failed:
1)Past Due

Any help is appreciated

------------------------------
Brandon Clark
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    The Advanced Properties for the table has a Data Validation Rule loaded which causes an error message and blocks the save.  The way a data validation rule works, is that it will only allow the save if the error calculates to blank.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement