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
Hi, I am working on setting up cross sheet references in SmartsheetGOV and it seems that the #UNPARSABLE error I receive is pointing to the token being broken. My formula is below. When I enter in "reference another sheet" it takes me through the steps to reference, but then it is inserted into the formula as plain text…
I am having a hard time crafting a working formula. I have a Dashboard data sheet that I am pulling/calculating metrics into from other various Sheets. In one sheet, I have a date column {DID} and a Number Column {NOD}. I am trying to build a formula that will average the number column if the date column is in the last…
I continue to get an error #INVALID COLUMN VALUE with my formula below. I have two restricted date fields RFP Decision Date and Actual RFP Award Date. I want to add the Estimated Approval Time, which is a number days value to the Actual RFP Date or if that is blank the RFP Decision Date, where we have a value in the…
