I'm trying to calculate the values in a column if within a certain range, I am getting 0. Any help?l

Ktjohn

=SUM(COLLECT([Total]:[Total], Date:Date, NETDAYS(24 / 1 / 6, 24 / 30 / 6) = 30))

SoS | Dan Palenchar

Hello @Ktjohn,

Your syntax for NETDAYS is incorrect, you need to reference actual dates in your arguments rather than text that represents date. See below:

https://help.smartsheet.com/function/netdays

You could nest DATE() functions to correct this portion:

=SUM(COLLECT([Total]:[Total], Date:Date, NETDAYS(DATE(2024, 6, 1), DATE(24, 6, 30)) = 30))

I don't suspect this formula will work though based on how COLLECT() functions, I just wanted to show you what I can see is an error.

It's hard for me to recommend a solution without at least a screenshot of your Sheet. If you can provide that and some more info about what you are trying to accomplish I'll do what I can to help.

Ktjohn

https://community.smartsheet.com/profile/Dan%20Palenchar

Thanks for your help. Im trying to calculate the sum of a quantity of values if submitted between june 1st 2024 and june 30 2024