Sum for current month
I've returned with another query.
I'd want to create a formula that calculates the current month's sale value.
This should add the amounts in the "Amount in LC" column, but only when the 'Current ETA' matches the 'Current Month', which in this case is 5(May). It will become 6 (June) tomorrow.
The formula then should subtract the values mentioned in front of 'Out' statuses.
Help Article Resources
Check out the Formula Handbook template!