Need help - adding less than or equal value to a current formula



Currently I'm struggling to add <= value to my current formula code, my idea is to count for Order Numbers (Unique values) and Lines of Order Numbers of certain times.

since filter doesn't work in this code, I'd like to add a <= or >= value formula for Ship_Time, so my code filters can automatically generate statistics for certain times I need.

For Orders I am using this formula:

=COUNT(DISTINCT(COLLECT({New Sheet Range 2}, {New Sheet Range 1}, ="SZE")))

here I want to add for example ">=09:00:00"

For Lines formula:

=COUNTIF({New Sheet Range 1}, [Delivered By]@row)

looking for suggestions and help!

Thank you.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!