Hi there! I am hoping to create a Formula Field in Data Designer that compares the output of ‘Deployment Date’ & ‘First Notification Sent Date? My goal is for the field to return a ‘True’ or ‘1’ value if ‘First Notification Sent Date’ is LESS THAN ‘Deployment Date’, & a ‘False’ or ‘0’ value if ‘First Notification Sent Date’ is GREATER THAN ‘Deployment Date’.
Please let me know if this is possible &/or how you recommend making it happen! Thank you!!!
Best answer by matthew_lind
Hi
In this scenario, a CASE statement sounds like your ticket to success. CASE statements let you write IF-THEN statements. As soon as an IF criteria is met, you can populate a newly created field with the value of another field in your DD task, or you can give it a “hard-coded” value by picking “Custom”
More at this link, with an example:
+11Hi
In this scenario, a CASE statement sounds like your ticket to success. CASE statements let you write IF-THEN statements. As soon as an IF criteria is met, you can populate a newly created field with the value of another field in your DD task, or you can give it a “hard-coded” value by picking “Custom”
More at this link, with an example:
Thank you
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
