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

Options

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?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!