Formula for pervious month

Kashmala Zaman

Hello,

I need to construct a formula that will show the values of the last month in the history column.

Currently, the formula for OUT status is showing values for the current month : =SUMIFS([Amount after Change]:[Amount after Change], Status:Status, "OUT - to the next month", Archive:Archive, 0, [Original ETA]:[Original ETA], MONTH(@cell) = MONTH(TODAY()))

Thank You!

Andrée Starå

Hi @Kashmala Zaman

I hope you're well and safe!

Try something like this.

=
SUMIFS([Amount after Change]:[Amount after Change], 
Status:Status, "OUT - to the next month", Archive:Archive, 0, 
[Original ETA]:[Original ETA], MONTH(@cell) = MONTH(TODAY())-1)

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!

Andrée Starå

Hi @Kashmala Zaman

I hope you're well and safe!

Try something like this.

=
SUMIFS([Amount after Change]:[Amount after Change], 
Status:Status, "OUT - to the next month", Archive:Archive, 0, 
[Original ETA]:[Original ETA], MONTH(@cell) = MONTH(TODAY())-1)

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!

Kashmala Zaman

@Andrée Starå Thank you it works :) Take care !

Andrée Starå

@Kashmala Zaman

Excellent!

You're more than welcome!