Forum Discussion
Spilled Array based on different Time Periods and applied periods - Help Needed
I have another issue that I can't solve. Most info is in the attached example sheet I have a set of time periods start and end dates in rows across the top running from a few historic years to a few...
To handle this, you can create a spilled array formula that checks each time period and flags when the expense should occur based on the start date, end date, and applied period. Here's a general approach:
For each expense, use SEQUENCE() or similar to generate a series of applied dates (e.g., starting from the start date and repeating every X months).
Use IF() or FILTER() to check if each generated date falls within the range of the time periods at the top.
Populate the flags https://nullbrawll.com.tr based on the matches.
If you can share more specific details from the attached sheet (like columns used), I can provide a more detailed formula.
- Thanks for all the incredible feedback and seeing the intellectuals corresponding!! I'm on a biz trip this week and travelling lots so only short chances to review on my tiny screened laptop. I will study in detail all when I get back this coming weekend. Many thanks
