Automatic Status Indicator (Red and Green) based on Dates

Follow

Permanently deleted user

• 14 February 2018 16:56
• Edited

If you need to automate your Status Indicators to reflect Actual Dates vs Planned Dates, here is a quick example with the expression used for this example.

Expression for row one - Start / End Project

if(isValidDate([Milestones_Summary_ActualEnd]) = false || isValidDate([Milestones_Summary_PlannedEnd]) = false, 'Unset',
if([Milestones_Summary_ActualEnd] > [Milestones_Summary_PlannedEnd] || [Milestones_Summary_ActualStart] > [Milestones_Summary_PlannedStart], 'Red','Green')
)

Note: The field names on this expression are specific for this example.

0

• 

  Charles Barker

  • 22 November 2019 11:47

  Thanks form sharing Mercedes - I am looking to do something similar - where is this code placed.

  0

  Comment actions Permalink
• 

  Permanently deleted user

  • 22 November 2019 17:21

  Hello Charles, can you confirm that you are a current Softools platform app builder? Thanks. 

  0

  Comment actions Permalink

Please sign in to leave a comment.