Sign in to join the conversation:
Can someone tell how to set up reminders for specific time 330pm 4th April, not just date like 4th April
I'm sorry, this isn't possible. Smartsheet sends out daily reminders between 12am and 4am PST (I Think) there is no way to set the specific time you receive daily emails. And the server processes them at during those times when (I imagine) the hit will be less impacting on Smartsheet users?
Mike, thanks for prompt response, at least I know the rules. Hope it will change over a time.
You could always submit a Product Enhancement Request.
I think it runs deeper than a simple product enhancement request gents. Smartsheet has real issues with calculating values based on system dates: https://community.smartsheet.com/discussion/bug-comparing-maxsystem-date-system-date-returns-incorrect-result
Correct. As the server time and our system time do not align. But that can be addressed as part of the system enhancement. There is no reason why scheduling emails based on our timezone couldn't happen. Simple math. But a necessary update with or without scheduled emails.
Yep, I totally agree with your appraisal of the situation and the suggestion that the issues with system times could be addressed by the enhancement. But honestly, the responses I've had from Smartsheet about this bug are less than heartening. Smartsheet are still trying to come up with a workaround (2 years down the track) as they are unable to get their head around what happens to sheets when they are opened by users in different time zones.
Despite correspondence with their product team, including a detailed Product Enhancement request complete with mockup images, I have not seen any movement on a resolution. I made a simple suggestion that the sheet owner could set the timezone value for the sheet (with the default being the Owner's locale) using the same mechanism available to specify working days, predecessors etc.
I'm using a sheet for a project plan. I have a % Complete column and a manual dropdown column for Status (options are Not Started, In Progress, Completed, At Risk, etc.). I want to change the Status column to "Complete" when the % Complete for a task is changed to 100%. Screenshot of my automation set-up is below. Can…
Hi, I have a large project plan, and sometimes I get lost among all the information when trying to locate specific tasks in the Gantt chart. Does Smartsheet have a feature similar to Microsoft Project that allows you to quickly scroll to or find a task?
We have multiple projects for 150+ countries and we want to create a heatmap style grid to track which project is live in which country. Ideally, we want to convert this grid into a timeline, what would be the ideal way to create this smartsheet?
