Formula not pulling data

alys

I have imported Clockify timesheet data from a csv file into Smartsheet. I am trying to pull number of hours spent on a project and project task per month. When I enter the formula, no data is returned - not even an error message. What am I doing wrong?

Formula I'm using: =SUMIFS({TEST - Timesheet duration decimal}, {TEST - Timesheet project}, [Primary Column]2, {TEST - Timesheet Task}, [01 - Research]2, {TEST - Timesheet start date}, >=DATE(2025, 1, 1), {TEST - Timesheet end date}, <=DATE(2025, 1, 31))

screenshot of helper sheet:

screenshot of source sheet; using highlighted columns in formula above:
The date columns are set to date only.

Melissa Yamada

Hello @alys

When the formula shows blank without any error message it just means that your formula is correct but there were no data that meet your criteria to sum on your source sheet.

Make sure your dates(jan 1 to 31), [Primary Column]2 and [01 - Research]2 are available on your source sheet. When it comes to values make sure that the value you have on your metric sheet is the same format and spelling on what you have on your source sheet.