I am attempting to create a true/false formula. What am I missing?

Natalie K

I am attempting to create a formula that will show an expected go live date 42 days after the created date for the project type (Union) and 14 days after the created date for the project type (Share).

The first half of the formula produces a date but when I add on I receive the error "UNPARSEABLE"

=IF([Application Product]@row = "Union", [Created Date]@row + 42), IF([Application Product]@row ="Share", [Created Date]@row+14))

How can I correct this formula?

Paul Newcome

Try removing the closing parenthesis after the 42.

Paul Newcome

Try removing the closing parenthesis after the 42.

Natalie K

Thank you so much for your quick response, this corrected the formula. I appreciate your help!

Paul Newcome

Happy to help. 👍️