Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 24, 2024 06:52 AM
Hey there. I came soooo close to getting a working formula for what I was trying to achieve but fell at the last hurdle.
I have a date field and a number field from a lookup. I am trying to create a formula that gives me a new date based on the the date field and the plus or minus number in the lookup number field. I am using this formula currently which is working and showing the new dates correctly.
Solved! Go to Solution.
Sep 24, 2024 07:10 AM
Sep 24, 2024 07:10 AM
Hello,
Try the formula:
Regards,
Pascal
Sep 24, 2024 07:18 AM
As easy as that, feel sheepish posting in the first place now 🤣