Sign in to join the conversation:
I need a formula (similar to an AVERAGEIFS statement in excel) to give me the average of the numbers in the right column if the value in the left column is prior to today's date. Thanks!
@David Yowell we have AVERAGEIF in Smartsheet, but not AVERAGEIFS, so a little workaround is needed here.
My suggestion would be to use a SUMIFS counting the numbers that meet the criteria of a date before today, divided by a COUNTIF counting the dates in the date column that are before today, which would give you your average of those numbers that met the SUMIF condition. Something like this:
SUMIFS(NUMCOLUMN:NUMCOLUMN, DATECOLUMN:DATECOLUMN, < TODAY()) / COUNTIF(DATECOLUMN:DATECOLUMN, < TODAY())
Would that work?
Thanks,
Alex
Hi @David Yowell
AVERAGEIF should be working here.
=AVERAGEIF([Left Column]:[Left Column], < TODAY(), [Right Column]:[Right Column])
Hope it helped!
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?
I looking to find unique values, in order, and separate them into columns. The "Client Update Date" column will contain dates, not in order and some dates may be duplicated. In the "1st Date Feedback I'm getting the correct date of 12/12/25 with the formula: =MIN([Client Update Date]:[Client Update Date]) In the "2nd Date…
