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

Time Elapsed to Today in Months/Years
Hi! I'm trying to figure out how to use the NETDAYS formula to show how long someone has been a member of a certain team. I can't get it to measure to today using the formula that the website suggests. I want it to be running so that whenever I log on I can see the time elapsed to the day I'm looking at the sheet. Can…
Formatting not working
Im doing cumulative formula and the cells will not format properly. Tried moving the info to a new sheet but still wont format. Help! IF([Column 26]72 = 0, "", VALUE([Column 26]72) + VALUE([9]@row ))
COUNTIF formula not counting correctly
Need some help with a formula that doesn't seem to be working. For context, here is a description of the sheet setup and formulas I'm using (+ I've attached an image with screenshots of all the pieces as a visual aid). The sheet I'm working on is our RAID log template that we have built into our control center solution. We…