Linking on Only Current Month Data

Peppey

Hi everyone. I am hoping you can help me. I have rows of data by month with column titles. I need to have a row that only shows the current months information. I have researched the community and found an index with children formula but it does not seem to be working. I have pasted the formula below I pasted in the first row (parent row) as well as an example of the sheet.

=INDEX(CHILDREN(), MONTH(TODAY())

Thanks everyone. Brian

Andrée Starå

Hi @Peppey

I hope you're well and safe!

You'd need to reference a date column to check if the month you want to include is today.

Make sense?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!