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.
Please check the syntax of your entire formula. Possible culprits are a mismatched set of parentheses, missing quotes, or an extra bracket.
Contains ([Product Name],"Certified", AdjustYear([Order Date],1),
Contains ([Product Name],"MicroDegree", AdjustYear([Order Date],1)
More on syntax errors...