I need help writing a formula.
Here is what I have. It is a sales table so it has basic sales fields.
I need the formula to held in a date formula field called "Renewal Date"
So, this date formula needs to:
Look at the product name > if it contains the text "Certified" or "MicroDegree" in the product name.
Then add 365 days (ie 1 year) to the purchase date. Which will end up being a renewal date in this field.
I hope that makes sense.
 0 Points
Posted 4 years ago
dwhawe, Champion
 744 Points
This is untested:
If(
Contains([Product Name],"Certified",AdjustYear([Purchase Date],1),
Contains([Product Name],"MicroDegree",AdjustYear([Purchase Date],1))
If(
Contains([Product Name],"Certified",AdjustYear([Purchase Date],1),
Contains([Product Name],"MicroDegree",AdjustYear([Purchase Date],1))
 0 Points
Thank you buddy.
I changed it slightly due to the field names
If(
Contains([Product Name],"Certified", AdjustYear([Order Date],1),
Contains([Product Name],"MicroDegree", AdjustYear([Order Date],1)
)
But its throwing a syntax error. Any advice would be great.
I changed it slightly due to the field names
If(
Contains([Product Name],"Certified", AdjustYear([Order Date],1),
Contains([Product Name],"MicroDegree", AdjustYear([Order Date],1)
)
But its throwing a syntax error. Any advice would be great.
dwhawe, Champion
 744 Points
What is the error? I made the suggestion based on assuming it is a formuladate field.
dwhawe, Champion
 744 Points
 0 Points
Formula syntax error
Please check the syntax of your entire formula. Possible culprits are a mismatched set of parentheses, missing quotes, or an extra bracket.
If(
Contains ([Product Name],"Certified", AdjustYear([Order Date],1),
Contains ([Product Name],"MicroDegree", AdjustYear([Order Date],1)
)
More on syntax errors...
Please check the syntax of your entire formula. Possible culprits are a mismatched set of parentheses, missing quotes, or an extra bracket.
If(
Contains ([Product Name],"Certified", AdjustYear([Order Date],1),
Contains ([Product Name],"MicroDegree", AdjustYear([Order Date],1)
)
More on syntax errors...
dwhawe, Champion
 744 Points
Close the parenthesis after closing quotes of Certified and MicroDegree
If(
Contains ([Product Name],"Certified"), AdjustYear([Order Date],1),
Contains ([Product Name],"MicroDegree"), AdjustYear([Order Date],1)
)
If(
Contains ([Product Name],"Certified"), AdjustYear([Order Date],1),
Contains ([Product Name],"MicroDegree"), AdjustYear([Order Date],1)
)
 0 Points
 0 Points
Related Categories

Forms
 3249 Conversations
 130 Followers

Formulas & functions
 2897 Conversations
 72 Followers

Relationships
 2608 Conversations
 45 Followers

Roles & permissions
 2241 Conversations
 22 Followers

Tables & fields
 7187 Conversations
 179 Followers