on ‎2021 Aug 19 10:45 AM
Dear Experts,
I am struggling with defining the correct UI Rule condition for following scenario:
IF Root.EndTimePoint < TODAY AND Root.LifeCycleStatusCode = Open THEN Root.EndTimePoint should be the color BAD_DARK if the criteria don't match then GOOD_DARK
I managed to set up the IF rule without taking the status into consideration but it's quite irritating to have quotes marked as overdue if they are closed.
Is it possible to set this up?
Your help is highly appreciated!
Kind regards,
Kerstin
Request clarification before answering.
Hello Kerstin,
Based on this conditions IF Root.EndTimePoint < TODAY AND Root.LifeCycleStatusCode = Open THEN Root.EndTimePoint should be the color BAD_DARK if the criteria don't match then GOOD_DARK
The following rule will attend it:
IF(AND(Root.EndTimePoint < TODAY(),Root.LifeCycleStatusCode == 1),'BAD_DARK','GOOD_DARK')
In case of any issue or further clarification is required, please let me know.
BR,
Vandré
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Vandré,
Thank you very much for your quick help - that's exactly what I was looking for!
Have a great day.
Kind regards,
Kerstin
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.