I want to have a Function statement in Smartsheet that identifies if a Date is entered in another field, then an Auto-Number (sort of) is created in the Primary column.
So, IF Week Ending = "yes", THEN Week = "prior row number +1"
Hi @Dan Eshleman
There isn't a way to automatically be able to reference the row above in a formula, you would need to add in some Helper Columns with other formulas to help get that information. @Leibel S has a great solution for how to do this on this other post, here.
Create 2 columns:
This will allow you to run a check on a previous row value by using Index(column:column, [ROW#]@row -1)
Would this work for you? I'm not sure I quite understand how you're looking to number your rows. It would be helpful if you could post a screen capture with a few more rows of data identifying what you want the formula to do, if possible.
Thanks!
Genevieve
Possibly. I got stuck in some other issues on other projects. I will take a look at this solution. Thank you!
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.
