Format rule based on time Answered

Lian Martin

Is it possible to use a format rule based on time on the B1 Dashboard? I have created a widget which shows all activities but I want to highlight those which have over run their time in red. It doesn't seem to recognise the EndTime column as date time unless I convert it but when I convert it the default date of 01/01/1900 comes up and that throws all the formatting expressions out the window.

Comments

1 comment

  • Comment author
    Yaremi Miranda Lopez
    • Official comment

    Hello Lian,

    You need to add a Rule but you need to change the "Calculated by" to the field that you need before adding the condition.

     

Please sign in to leave a comment.