I have a project that needs to count how many lines are added on a particular day. I found that dates convert to the next day after 7:00 pm. I've tried (=dateonly) and the date still advances after 7:00 pm. I need to be able to capture based on the true date. Does anyone have an insight into a solution?

Thank you


This is a highly annoying problem that is because of how the system date is being calculated. Its being captured at their server's time zone instead of the user's local setting. This is one of the primary reasons why time tracking does not work well in smartsheet. :\ I do not know of a fix, but welcome you to submit a product enhancement request asking them to display the system date/time column settings in the users' time zone. 

Manual entry of the date may be needed.