Forum Discussion

WardHolberg's avatar
WardHolberg
Qrew Trainee
8 years ago

Syntax error on IF statement in date formula. HELP

I am trying to use a date formula to calculate a date if a checkbox is unchecked or allow a user to enter a date if a checkbox is checked. IF([Verification Extension] = 1, Date(yyyy, mm, dd), [Actu...
Ask about Quickbase functionality
Formulas and functions
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
You cannot enter data into a formula field.

So, if you want data entry you will need to create a new field and then have a formula determine how to use that field.

Perhaps what you want is this

If([Verification Extension] = false, [Actual Date for Corrective action Implemented]+Days(14),
[My manual data entry field])

Then you would have a form rule to which says

When [Verification Extension] is not checked:

Show [My manual data entry field]
Require [My manual data entry field]