Sign in to join the conversation:
=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
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
I am trying to turn off weekly backups, but it's not checked and it shows no history, yet I get backups every week. Is this a bug or there is another place I have to disable it? If it's the right place, why is there no history now?
I'm searching another sheet date column for the max date where two number columns (CID) are equal. It works fine, but if the list of dates contains a blank, I want the formula to return a blank instead of the max date it finds. =MAX(COLLECT({DAFD}, {CID}, @cell = [CID]@row))
I can't quite get the filter to align with my intent. I'm either pulling every status when I want to exclude "Complete" tasks or I can't get parent rows for my project schedule. I want the attached report to do the following for ease of presentation past due AND upcoming activities. Status is one of Not Started or In…
