Welcome!

sumif formula

=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

2018-09-22 (2).png

Finance

Formulas

Services

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

Sum values from child rows automatically with formula while allowing manual data entry into child row cells
We have a project plan with resourcing allocation built in to it (hours and budget) Currently we have a column for Allocated Hours where we are having to manually enter the below formula into the parent rows. I have figured out a work around by having a secondary column that I have hidden to sum the hours from the child…
Autopopulate Cells Else New Entry
I am trying to create a New Order Entry form. I have a dropdown list that references our customer sheet. If the customer is not listed, you can choose "(NEW CUSTOMER)", which allows more fields to open up to add the new customer info. If the customer is listed, can I have the address autopopulate into the appropriate…
Query: Extract Day (Thu) from Date Column
Hi, this column is a date column. I need to extract the day (like Thu) from it for each row. Could you please suggest a formula?