Formula not pulling data

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.

Find more posts tagged with

Formulas

Accepted answers

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.