How do I change when my Sheet starts the next workday?

Jules42
Jules42 ✭✭✭
in Formulas and Functions

I have a formula in Sheet Summary that counts workdays remaining until launch. It works except that the count doesn't go down each day until 10 AM. If anyone looks at it before 10 AM, it shows an extra day. I can't figure out why it updates at 10 AM, so I don't know how to fix it. Ideally, it would change at midnight.

Tags:
· Share on FacebookShare on Twitter

Best Answer

  • Itai Perez
    Itai Perez ✭✭✭✭✭✭
    edited 12/19/23 Answer ✓

    Hey @Jules42 ,

    What time zone is your account set to? Are you sure it updates at 10am and not updates when someone opens and saves the sheet?

    Itai Perez

    Reporting and Project Manager

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

    · Share on FacebookShare on Twitter

Answers

  • Itai Perez
    Itai Perez ✭✭✭✭✭✭
    edited 12/19/23 Answer ✓

    Hey @Jules42 ,

    What time zone is your account set to? Are you sure it updates at 10am and not updates when someone opens and saves the sheet?

    Itai Perez

    Reporting and Project Manager

    If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂

    https://www.linkedin.com/in/itai-perez/

    · Share on FacebookShare on Twitter
  • Jules42
    Jules42 ✭✭✭

    That's a great point. It does look like it's when someone opens the sheet. That's problematic.

    Thank you for the insight.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!