IF statement issue, can seem to get it to work

I can do it in Excel but cant seem to get it right in Smartsheet.

I need to categorize for an age analysis - Current, 30 days, 60 days, 90 days etc.

=if(([Aging Days]@row>30,"Current"),if([Aging Days]@row>30<60,"30 Days"),if([Aging Days]@row>60<90,"60 Days"),if([Aging Days]@row>90<120,"90 Days"),if([Aging Days]@row>120<150,"120 Days"),if([Aging Days]@row>150<180,"150 Days"),if([Aging Days]@row>180,"180 Days"))

Please help, it works if I do one argument.

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try this...

=IF([Aging Days]@row > 180, "180 Days", IF([Aging Days]@row > 150, "150 Days", IF([Aging Days]@row > 120, "120 Days", IF([Aging Days]@row > 90, "90 Days", IF([Aging Days]@row > 60, "60 Days", IF([Aging Days]@row > 30, "30 Days", "Current"))))))

Roxanne

Thanks @Paul Newcome I managed to get it right.

=IF([Ageing days]@row < 30, "Current", IF([Ageing days]@row < 60, "30 Days", IF([Ageing days]@row < 90, "60 Days", IF([Ageing days]@row < 120, "90 Days", IF([Ageing days]@row < 150, "120 Days", IF([Ageing days]@row < 150, "150 Days", "180 Days"))))))

Paul Newcome

Yup. There you go. Same concept but in reverse order. Hahaha.

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.