Sum up values if it falls within a period


Hi all

Im trying to have a formula to sum up the allocation % if it falls within a specific date range with the sheet summary function. However, I returned an error. Im not exactly sure where i went wrong.

Formula used:

=SUM(COLLECT([Allocation % - SS]:[Allocation % - SS], [Start Date]:[Start Date], >=(2023, 1, 1), [End Date]:[End Date], <=DATE(2023, 3, 31)))

Thank you for advising!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!