Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 11, 2024 11:06 PM
I have a formula field that gives me a date.
then I have a normal date field "current". For example, if I enter a date in the "Current" date field, then the formula field should calculate 2 years from this date and give me the date in 2 years
Example: “current” has the value: October 1st, 2020
Formula field calculates 2 years further
10/1/2022
works quite well so far
If the “current” field is empty then the formula field should take the date of “approval” and calculate 3 years from there.
Example:
“Approval” has the value: October 1st, 2017 then the formula field calculates 3 years further so: October 1st, 2020 also works.
but every time this formula is executed, I get a linked table
a new data set is simply created even though this is not what is wanted.
here is my formula:
DATETIME_FORMAT(IF({Letzter HU/ AU Termin}, DATEADD({Letzter HU/ AU Termin}, 2, 'years'), DATEADD({Erstzulassung}, 3, 'years')), 'MM.YYYY')
Sep 12, 2024 01:10 AM
Hm, formulas cannot create new tables so I think I might not be understanding what you're saying
Could you provide a screenshot with all 3 fields in it and point out where the issues are?
Sep 13, 2024 04:23 AM
It turned out that an automation had something to do with the creation of a new data record.