I have a Google Sheets spreadsheet which is populated from a Google Form. The spreadsheet contains the following columns:
I want to be able, to sum up, the numericValue column for all rows that were added in the last 24 hours.
I have tried the following formula on a second sheet:
=dsum('Form responses 1'!A:B,"numericValue", Criteria!A1:A2)
And on a third sheet (Criteria) have the following in column A:
Timestamp >=now() - 1
I always get a count of zero, I assume DSUM isn't parsing my criterion correctly.
Is there another simple way to achieve what I want?