Embedding a value expression to compare 3 values for display

[TroyBu]

If anyone can please help me figure out how to do a value expression comparison for 3 fields, it would be greatly appreciated. What I am trying to accomplish, I have 3 date fields: Actual Go Live Exit, Go Live at Latest CR, and Go Live at Plan Exit I would like to display the Actual Go Live Exit if the project has passed Go Live, if not then I would like to display Go Live at Latest CR if they had a change control or if not then Go Live at Plan Exit. Here is the code I have written and it is not working, it is coming up blank: I have been successful comparing 2 fields with value expression but not 3. displayname=Go Live textmode=true valueexpression=IF(ISBLANK({DE:Actual Go Live Exit}),{valueexpression=IF(ISBLANK({DE:Go Live at Latest CR}),{DE:Go Live at Plan Exit},{DE:Go Live at Latest CR}),{DE:Actual Go Live Exit}) valueformat= Please let me know if you see any corrections to make this work. Thanks, Troy Troy Burwell SecureWorks

[Doug_Den_Hoed__AtAppStore]

Hi Troy, Just a typo, I suspect (as only one "valueexpression=" directive is needed), so instead of: valueexpression=IF(ISBLANK({DE:Actual Go Live Exit}), {valueexpression= IF(ISBLANK({DE:Go Live at Latest CR}),{DE:Go Live at Plan Exit},{DE:Go Live at Latest CR}),{DE:Actual Go Live Exit}) I suggest you try: valueexpression=IF(ISBLANK({DE:Actual Go Live Exit}),IF(ISBLANK({DE:Go Live at Latest CR}),{DE:Go Live at Plan Exit},{DE:Go Live at Latest CR}),{DE:Actual Go Live Exit}) Regards, Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads

[TroyBu]

Doug, Thank you sooo much!!!! That did it! Just needed another set of eyes and someone with much better coding skills! Thanks again! Troy Troy Burwell SecureWorks

[Doug_Den_Hoed__AtAppStore]

My pleasure, Troy, and I agree: I'm considering getting an extra pair of eyes installed, myself... Regards, Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads