Forumal Help

Lisa B 2022

Lisa B 2022 ✭✭✭✭

07/21/22 in Formulas and Functions

Hi

Would anyone have a correct formula for =sum of {range}, if {date range}is less than a specific date

So I'm adding values in a column, I have another column of dates, I want the formula to add the values only if they are less than 01 01 2022.

Anyone?

0 ·

Answers

Hollie Green Community Champion

07/21/22

=Sumif({date range},<Date(2022,1,1),{range to sum} should work

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Select Most Recent Date In List
Hello! I need a formula to pull the most recent date in a list, but I keep getting unparsable and invalid errors. Could someone please help me create a formula to put in the highlighted cell? Please note there are empty dates (like the top row). This sheet is driven by a form, so new dates may be added out of order - in…
Numerical value established by a formula not seen as a number
Hello I have used the mid formula to break down a date and indicate the number of the month only in a field. =MID([Start Date]@row, 2, 1). This is all working fine. I want to run an automation where if the value of this field is less than 5 do x. However it is not seeing the value as a number and is thus returning zero…
Formula or Automation to Indent Rows from Intake Form?
Is it possible to set up a formula or automation with helper columns in a sheet so that if a box is checked (or some other designation that could be done from an intake form…) it can indicate that a task is a sub-process of a larger task and be indented to indicate that relationship? Trying to find a way around manually…