One of the parameters is invalid - multiple IFs

Platform discussions Special workflows & use cases
1

I have tested each IF statement and they all work by themselves, but combined together this does not work. Where am I going wrong?

, IF(AND({Days Between} = 365, {Day of Week or Month or mm/dd Year} <> 0), FORMAT_DATE(ADD_DAYS({Completed On},365),“MM-DD-YYYY”,

IF(AND({Days Between} >= 28, {Days Between} <= 31, {Day of Week or Month or mm/dd Year} <> 0), FORMAT_DATE(DATE(YEAR(ADD_DAYS({Completed On}, {Days Between})), MONTH(ADD_DAYS({Completed On}, {Days Between})), {Day of Week or Month or mm/dd Year}), “MM-DD-YYYY”),

IF(AND({Days Between} = 7, {Day of Week or Month or mm/dd Year} <> 0), FORMAT_DATE(ADD_DAYS(TODAY(), {Day of Week or Month or mm/dd Year} - WEEKDAY(TODAY())),“MM-DD-YYYY”),

IF(AND({Days Between} = 1, {Completed On} <> TODAY()), FORMAT_DATE(TODAY(), “MM-DD-YYYY”),

IF(WEEKDAY(ADD_DAYS({Completed On}, {Days Between})) = 7, FORMAT_DATE(ADD_DAYS({Completed On}, {Days Between} + 2),“MM-DD-YYYY”),

IF(WEEKDAY(ADD_DAYS({Completed On}, {Days Between})) = 1, FORMAT_DATE(ADD_DAYS({Completed On}, {Days Between} + 3),“MM-DD-YYYY”),

FORMAT_DATE(ADD_DAYS({Completed On}, {Days Between}),“MM/DD/YYYY”)

))))))))

2

@jpendleton,

It looks like you haven’t copied the formula exactly. There is a leading ", ".

2 other issues with the formula are: 1) missing “)” on first line and a missing “)” at the end.

Jim - The Monday Man

3

Thank You, I did find that and still couldn’t get it to work, but I was able to get it to work using WORKDAY, which was complicated but achieved my purpose. Have a wonderful day!