Format rule based on time

Answered

Lian Martin

• November 08, 2019 16:03

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.

Vote

0

• Official comment

  

  Yaremi Miranda Lopez

  • February 17, 2020 21:41

  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.