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.
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
I have had approval workflows and notifications built into a couple sheets for about a year now. In the past month, I am getting a lot of feedback saying people did not receive the email request for approval or notification email. It isn't all the time, just sometimes and there does not seem to be a pattern on which ones…
