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.

Conditional Formatting Help

Options
Siobhan
Siobhan ✭✭
edited 12/09/19 in Archived 2017 Posts

Is there a way to highlight a row when a box is not checked by a certain time. We are trying to use as sort of a time clock, and our boss wants a way to easily track who is not on time. For example, making the row highlight to red if the box is not checked by 8am. Does anyone know a way to do this? 

Comments

  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭
    Options

    Siobhan

    What you seek is not available in Smartsheet without changing your requirements. However you can very easily get your boss what they need on a daily basis by using Reports to provide to do Lists for individuals or a "Whats running late" Report that you boss can monitor in Real time. 

    Smartsheet is unable at present to measure time in amounts of less than a day as you describe but i'm sure with a little imagination you can design a workflow that achieves what you need or 90 % of it? 

    Good luck and hope that helps? 

    RichardR

This discussion has been closed.