=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
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…
Hello Smartsheet Community! I created a formula that tracks the number of days away from the deadline that I posted on my dashboard as a visual for my students. =IF([Deadline Date]@row < TODAY(), "🔴 Past Due (" + ABS([Deadline Date]@row - TODAY()) + " days ago)", IF([Deadline Date]@row = TODAY(), "🟠 Due Today",…
Hello, I am trying to get this formula to work but am not having any luck. When I remove the last @cell….text below the formula works great. When I add it in I get an error. Any ideas? =COUNTIFS([ACCT READINESS STATUS PLV]:[ACCT READINESS STATUS PLV], OR(@cell = "PENDING LOCAL CAH", @cell = "ADDITIONAL REVIEW NEEDED LOCAL…
