Increment by 1 evey time cell greater than 18k or not blank

I am trying to add an index or grouping every time a cell is not blank. In the image below I have a multi row formula that adds a month to the Minimum new date value every time the running total exceeds 18k. Ideally I need to add month everytime so the NextMonth column would be 10-27-2022 at the first 18k and then 11-27-2022 at the second 18k. I could not figure out how to do that so I thought maybe I could add an index every time NextMonth is not empty. Anyone have any ideas??

MultiRow

Included sample data with desired output. Basically in the output tab, every time the running total is 18k or more, add 1 month to the Minimum date. So in this data set, the next month would range from 9/27/2022 - 12/27/2022

SampleData.xlsx

Workflow

Accepted answers

oneillp111

Solved my issue by adding a Record ID and Tile on Unique values, utilizing the Tile Sequence number as the months to add to Minimum ship date.

All comments

binu_acs

@oneillp111 Can you provide some sample data and expected output

IraWatt

Hey @oneillp111,

Here's one example of how to do this:

Example 23.yxmd

binu_acs

@oneillp111 Another way of doing this with the formula tool

MonthAdd_23_05.yxmd

oneillp111

I added a sample set with output tab

oneillp111

@binu_acs thanks for this but this would only chnage the date to 10/27. I need to increment everything the running total hit 18k. So it would go all the way to 12/27/2022.

binu_acs

@oneillp111 attaching the updated workflow

MonthAdd_23_05.yxmd

oneillp111

Solved my issue by adding a Record ID and Tile on Unique values, utilizing the Tile Sequence number as the months to add to Minimum ship date.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703