Problem with my formula,working for first part but not for the last part.

Hi, My formula works for the first 10,9 and 8 but for the others i get invalid operation. the formula is below . Time criticality is a requested go live date/ current date

=IF([Time Criticality]@row <= 30, 10, IF([Time Criticality]@row <= 60, 9, IF([Time Criticality]@row <= 90, 8, =IF([Time Criticality]@row <= 120, 7, IF([Time Criticality]@row <= 150, 6, IF([Time Criticality]@row <= 180, 5, =IF([Time Criticality]@row <= 210, 4, IF([Time Criticality]@row <= 240, 3, IF([Time Criticality]@row <= 270, 2, IF([Time Criticality]@row <= 300, 1))))))))))

is there an error from 120,7 down to 300,1?

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Try removing the = from between the 8 and the IF. Same with the = between the 5 and the IF.

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.