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
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
Comments
-
Just trying a couple of things to try and fix this.
I changed the "Job Date" column properties from "Date" to "Text/Number" and the formula worked!
I need to keep the column proerties as Date... Just need help in getting the formula to recognise the date in "Date" mode.
-
Instead of "30/03/17" have you tried using the DATE(year, month, day) function?
-
Tried that, with variations on date format... does not work unfortunetly!! Hmmm.....
-
Changed the format from
DATE(2017, 03, 28) to DATE(2017, 3, 28)
Removed the "0" from the month and this resolved the issue.
Thanks for your help... Much appriceated.