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!
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
Is there a way to display for one specific columns cell history display in another column for calculation purpose? I wanted to count each stage from one specific column by getting cell history in separate column to calculate duration. Thank you!
I want to use a list of account numbers in one sheet for a dropdown in another sheet using Table View. When I select the sheet and column in the dropdown menu, it shows the correct column but is dropping zeros. I have provided a screenshot of the reference column and then what appears in the drop down. Any ideas?
