Calculated Field on Custom Form

[KimberlyHo]

I'm trying to create a calculated field off of a "requested live date" calendar drop-down. I want to Display a "reason for rush" field IF the date is less than 2 weeks. Can anyone help? My best, Kim Kimberly Hodnett Mgr. Project Management | Communications Medtronic 555 Long Wharf Drive | New Haven, CT 06511 | USA Office 203.821.2191 kimberly.n.hodnett@medtronic.com "http://www.medtronic.com/"> medtronic.com | "https://www.facebook.com/Medtronic"> Facebook | "https://www.linkedin.com/company/medtronic?trk=biz-companies-cym"> LinkedIn | "https://twitter.com/Medtronic"> Twitter | "https://www.youtube.com/user/MedtronicCorp"> YouTube LET'S TAKE HEALTHCARE FURTHER, TOGETHER This message has been marked as Medtronic Controlled [CONFIDENTIALITY AND PRIVACY NOTICE] Information transmitted by this email is proprietary to Medtronic and is intended for use only by the individual or entity to which it is addressed, and may contain information that is private, privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please delete this mail from your records. To view this notice in other languages you can either select the following link or manually copy and paste the link into the address bar of a web browser: http://emaildisclaimer.medtronic.com

[BarryBu2]

There are two elements at play here - Calculated field and display logic. A calculated field will only display after the request/issue/form is saved. So it won't dynamically say if it's under two weeks and do things while you're filling in the form. Display logic can only work of drop-down, radio button or check boxes that precede it in the form. So, what you might want is a mandatory drop down for 'required delivery' that has two options 'Rush Job - less than two weeks' or 'Standard SLA - 2+ weeks'. Then a 'Requested Live Date' field that has two logic conditions - if either choice is made on 'Required Delivery' and a 'Reason for Rush' mandatory field that only displays if 'Rush Job' is selected. Barry Buchanan - WMA Work Management Australia