Repeating # formula

this is what i have - but not working

IF([row #]18, =1, "2", OR(IF([row #]18, =2, "3", OR(IF([row #]18, =3, "4", OR(IF([row #]18, =4, "5", OR(IF([row #]18, =5, "6", OR(IF([row #]18, =6, "7", OR(IF([row #]18, =7, "8", OR(IF([row #]18, =8, "9", OR(IF([row #]18, =9, "1",

i want if the row above is a 1, the next row to equal 2

but when it reaches 9 - to be assigned to 1

repeating 1-9 on each row - so when new items come in gets a

Find more posts tagged with

Formulas

Automations

Accepted answers

John Pudar

I agree with @Kimberly Loveless, you shouldn't need the OR function.

You can probably also shorten the formula to the following:

=IF([row #]18 = 9, 1, IF([row #]18 > 0, [row #]18 + 1))

All comments

Kimberly Loveless

I don't think that you need the OR functions. With nested IF statements if the first one is not met it automatically moves on to the next. So the formula below should work

=IF([row #]18=1, "2", IF([row #]18 =2, "3", IF([row #]18 =3, "4", IF([row #]18 =4, "5", IF([row #]18 =5, "6", IF([row #]18=6, "7", IF([row #]18=7, "8",IF([row #]18 =8, "9", IF([row #]18, =9, "1"

John Pudar

I agree with @Kimberly Loveless, you shouldn't need the OR function.

You can probably also shorten the formula to the following:

=IF([row #]18 = 9, 1, IF([row #]18 > 0, [row #]18 + 1))

Trish Dillon

@Kimberly Loveless - thank you. I tried it and it works for the first 9 numbers, (i dragged the formula down since i cant do a column formula on it )

so the one after 9, give #INVALID DATA TYPE

Screen Shot 2021-06-24 at 2.36.11 PM.png

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.