Multiple IF not working but if it is separated they are working

Condition 1

If Termination Date field empty = Active;

If Termination Date is before TODAY = Inactive

I tried the below in excel, it was working then it is not working in Smartsheet when lump together but separating the formula, it works!

Please help!

My formula is:

IF([Termination Date]@row=0, "Active", IF(TODAY()>[Termination Date]@row,"Inactive","Active"))

Find more posts tagged with

Accepted answers

All comments

Cristóbal Enrique Santibáñez Pavez

=IF(ISBLANK([Termination Date]@row); "Active"; IF([Termination Date]@row > TODAY(); "Inactive"))

Try this one, I tested it on a sheet and it worked !

Cristóbal Enrique Santibáñez Pavez

=IF(ISBLANK([Termination Date]@row); "Active"; IF([Termination Date]@row > TODAY(); "Inactive"; "Active"))

Sorry forgot one part.

yeoz

Thank you it is working with ISBLANK! but need to change ';' to , and formula behind upside down.

Thank you Cristobal!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.