This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 2%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
I have a list that comprising of 6 Action columns that when they have a text entry a corresponding Target column then requires a mandatory Target date.
These work for the Action and Target but I can't get the formula for more than once action.
=AND(LEN([Action])>0,(NOT(ISBLANK([Target]))))
=AND(NOT(ISBLANK([Action])), NOT(ISBLANK([Target])))
I have tried =IF(NOT(ISBLANK([Action])),NOT(ISBLANK([Target])),
IF(NOT(ISBLANK([Action1])),NOT(ISBLANK([Target1]))
))
and
=AND(NOT(ISBLANK([Action])), NOT(ISBLANK([Target])),AND(OR(NOT(ISBLANK([Action1])),NOT(ISBLANK([Target1])) )))
Any help?
Also tried this
=IF(OR(
AND(ISBLANK([Action]), NOT(ISBLANK([Target]))),
AND(ISBLANK([Action1]), NOT(ISBLANK([Target1]))),
AND(ISBLANK([Action2]), NOT(ISBLANK([Target2]))),
),
TRUE,
FALSE
)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Is there some mystical connection between Action1 and Action2 that is not present with Action3? Why does it matter that Action1-Target1 status be the same as Action2-Target2 status? If Action1 is filled in but Target1 is not, is that not a condition to be flagged regardless of Action2 status? What about Action3, 4, 5, and 6?
Do you want one single formula to identify any possible Action-Target mismatch? Does the formula need to identify which mismatch? What about multiple mismatches?
This worked =IF(ISBLANK(Action1),TRUE,NOT(ISBLANK(Target1)))=IF(ISBLANK(Action2),TRUE,NOT(ISBLANK(Target2)))
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 65%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hi @Dancer,
I'm glad to hear you solve the problem, if you have any issue about SharePoint, you are welcome to raise a ticket in this forum.
By the way, since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others.". and according to the scenario introduced here: Answering your own questions on Microsoft Q&A, I would post an answer make a brief summary of this thread, kindly accept the answer to archive this thread so that others who stuck in similar issues could get answered quickly.
Thanks for your understanding.
[SharePoint Validation for Multiple Actions and Multiple Target Dates]
Issue Symptom:
I have a list that comprising of 6 Action columns that when they have a text entry a corresponding Target column then requires a mandatory Target date.
These work for the Action and Target but I can't get the formula for more than once action.
Current status:
Solved by this formula:
=IF(ISBLANK(Action1),TRUE,NOT(ISBLANK(Target1)))=IF(ISBLANK(Action2),TRUE,NOT(ISBLANK(Target2)))
You could click the "Accept Answer" button for this summary to close this thread, and this can make it easier for other community members to see the useful information.