Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Help with SUMIF

Hugh McKinney
edited 12/09/19 in Archived 2017 Posts

Hi I am calculating time spent on work by Job Number and by Date

I have set up a SUMIF formula to add time spent by job number:

=SUMIF([Job Nº]:[Job Nº], "64501", Time:Time) - Works fine.

the formula to add time spent by date is:

=SUMIF([Job Date]:[Job Date], "30/03/17", Time:Time) - and the calculation comes out as "0"

Not sure what is going wrong here, is it something to do with defining the date correctly?

Thanks in advance



This discussion has been closed.