Sum up values if it falls within a period

Options

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!

Cheers

HuiXian

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!