As of today, we can only enter static fields for the add/subtract date formula. Has there been any consideration to allowing a dynamic component to this formula? So we can do something like “Renewal Date + (insert number field).” I think it’d be a nice enhancement and would be another step toward keeping customers in the Rules Engine instead of Excel.
New Idea
Add ability to tokenize a number field for Add/Subtract Date Formula
+3+100 to the Idea.
spencer_engel wrote:
As of today, we can only enter static fields for the add/subtract date formula. Has there been any consideration to allowing a dynamic component to this formula? So we can do something like “Renewal Date + (insert number field).” I think it’d be a nice enhancement and would be another step toward keeping customers in the Rules Engine instead of Excel.
+1Hi All,
This is on the short term roadmap and we have picked it up for analysis.
+5Just encountered this scenario due to variations in contract length, so the calculation cannot always be start date + 12 months
+4Looks like this is released now, but am I reading this right that I can only add days or weeks? I really need to be able to add months for my use case (and I imagine others will too, especially re: setting an NPS cadence for example).
Hello Everyone!
The Add/Subtract Date Formula field in the Date Formulas of Transformation Tasks now accepts dynamic fields. Previously, this field accepted only static numeric values as input. With this v6.16 release, the number of days you add to or subtract from a date dynamically changes with the value of the selected field.
Also, Gainsight introduces new Number Formulas to the Formula Fields in Rules Engine. These enable you to perform powerful calculations in your Transformation Tasks while setting up a rule.
This feature is implemented in both SFDC & NXT versions.
Thanks for posting!
1 person likes this
Reply
Sign up
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.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.