I am trying to return “Late” when one or several function fields have a date that’s before today AND an attachment field is empty. I have tried the following formula but it’s not working. What am I doing wrong?
IF(
AND(
IS_BEFORE(
{Due Date Sponsored Article},TODAY()),
{Assets}="",
“LATE”,
“Upcoming”)
IF(
AND(
IS_BEFORE(
{Due Date Sponsored Article},TODAY()),
{Assets}="",
“LATE”,
“Upcoming”)
IF(
AND(
IS_BEFORE(
{Due Date Sponsored Agenda},TODAY()),
{Assets}="",
“LATE”,
“Upcoming”)
IF(
AND(
IS_BEFORE(
{Due Date NL Banners},TODAY()),
{Assets}="",
“LATE”,
“Upcoming”)
IF(
AND(
IS_BEFORE(
{Due Date EMail Blast},TODAY()),
{Assets}="",
“LATE”,
“Upcoming”)
IF(
AND(
IS_BEFORE(
{Due Date Website Banners},TODAY()),
{Assets}="",
“LATE”,
“Upcoming”))))))
