MULTIPLE IF STATEMENT

Fialko66

Hi - Could anyone help me again please?

I got help with the formula above and it worked fine but then i've tried to adapt it to cover another scenario in a different date column - so it first looks at the start date column and if that date is not yet due then the column says not yet valid - if the date is today or past due then the formula above kicks in.

I have formulas for bothn working but when i stick them together (as i would have worked them out in Excel) then i get an error message again

Below is both fomulas and how i have tried to join them.

=IF([VALID FROM DATE]@row > TODAY(), "NOT YET VALID", "ADD NEXT PART OF FORMULA HERE")

=IF(AND([VALID TO DATE]@row < TODAY(30), [VALID TO DATE]@row > TODAY()), "EXPIRING", IF([VALID TO DATE]@row >= TODAY(), "CURRENT", "EXPIRED"))

=IF([VALID FROM DATE]@row > TODAY(), "NOT YET VALID”, IF(AND([VALID TO DATE]@row < TODAY(30), [VALID TO DATE]@row > TODAY()), "EXPIRING", IF([VALID TO DATE]@row >= TODAY(), "CURRENT", "EXPIRED")))

Nick Korna

The error looks to be caused by the ” at the end of the NOT YET VALID portion, if you change this over to " it should work:

=IF([VALID FROM DATE]@row > TODAY(), "NOT YET VALID", IF(AND([VALID TO DATE]@row < TODAY(30), [VALID TO DATE]@row > TODAY()), "EXPIRING", IF([VALID TO DATE]@row >= TODAY(), "CURRENT", "EXPIRED")))

Nick Korna

The error looks to be caused by the ” at the end of the NOT YET VALID portion, if you change this over to " it should work:

=IF([VALID FROM DATE]@row > TODAY(), "NOT YET VALID", IF(AND([VALID TO DATE]@row < TODAY(30), [VALID TO DATE]@row > TODAY()), "EXPIRING", IF([VALID TO DATE]@row >= TODAY(), "CURRENT", "EXPIRED")))

Fialko66

https://community.smartsheet.com/discussion/comment/398334#Comment_398334

Hi Nick

Apologies for the late reply - i went on annual leave a couple of days after posting so just got around to checking this. I have tried this and once again your help has worked and solved the problem for me. Thank you so much and apologies again for the late thanks

Nick Korna

No problem, glad the problem is sorted for you now and hope you had some nice time off! 😊