sumif formula
Options
Debbie J
✭✭✭✭✭
=SUMIF(Date past due: Date past due,>TODAY(), Amount:Amount)
#unparsable
The amount is coming from a vlookup from another smartsheet
The past due date is a formula with in the same sheet
Comments
-
I always use SUMIFS, so the syntax will be slightly different.
If the column name contains special characters (including spaces) or ends in a number it needs to be surrounded by [] square brackets.
=SUMIFS(Amount:Amount, [Date past due]:[Date past due], >TODAY())
Craig
-
thank you
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!