You need to sign in to do that
Don't have an account?
lburns
Required Field for Date Field
I would like to make the following rule:
If (addendum #) >0 (problem is that this was created as a text field; afraid I'll lose information if I change the data type) than both the following fields need to be required:
Date Field
Text Field
Thanks...
There's a couple of ways that you could approach this depending on what sort of data you have in your Addendum field.
You could use a formula to convert the value to a number, then evaluate it in a formula like this:
AND(
VALUE(Addendum) > 0,
OR(
LEN(Text) < 1,
ISNULL(Date)))
or you could just evaluate it as a text field and check to see if it is blank
AND(
LEN(Addendum) > 0,
OR(
LEN(Text) < 1,
ISNULL(Date)))
All Answers
There's a couple of ways that you could approach this depending on what sort of data you have in your Addendum field.
You could use a formula to convert the value to a number, then evaluate it in a formula like this:
AND(
VALUE(Addendum) > 0,
OR(
LEN(Text) < 1,
ISNULL(Date)))
or you could just evaluate it as a text field and check to see if it is blank
AND(
LEN(Addendum) > 0,
OR(
LEN(Text) < 1,
ISNULL(Date)))