@ row used to determine month and year but summary formula is now invalid

Melanie Sanders

Hi All,

I have successfully created an @row formula to automatically populate in a cell in my sheet which is super awesome. For this example I am showing the Month Reported but I also used a similar formula for Year Reported.

But now that I have that completed, my summary formula that previously worked no longer does. How can I fix this so it works again?

Thanks so much!

Andrée Starå

@Melanie Sanders

Happy to help!

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Andrée Starå

Hi @Melanie Sanders

I hope you're well and safe!

Try removing the " " around the numbers, so instead of "2019", it should be 2019.

Did that work/help?

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!

Melanie Sanders

Hello @Andrée Starå

Thank you for your speedy response. That didn't seem to work. I also have "" around the month as well. The @row feature was used for month and year cells.

Any other suggestions?

Thank you!!

Andrée Starå

@Melanie Sanders

Happy to help!

I'd be happy to take a quick look.

Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Melanie Sanders

Yes I will do that right now.

Thank you!

Andrée Starå

@Melanie Sanders

Glad we got it working!