Multiple IF function formula not working
I am wondering why my formula is unparseable:
=IF(Proof@row = "Waiting for Proof", [Proof Start Date]@row + 30), IF(Proof@row = "Family Service Rep", [Proof Start Date]@row + 14))
If my proof reads "Waiting for Proof" I'd like it to calculate a due date of 30 days from the proof start date. However, if the proof reads "Family Service Rep" then I'd like it to calculate a due date of 14 days after the start date. Columns are set to date for both proof start date and proof due date. Ideally I would like to add a third element.
I can get the formula to work with a single variable: =IF(Proof@row = "Waiting for Proof", [Proof Start Date]@row + 14)
Best Answer

Just take out the parentheses:
=IF(Proof@row = "Waiting for Proof", [Proof Start Date]@row + 30, IF(Proof@row = "Family Service Rep", [Proof Start Date]@row + 14))
Answers

Just take out the parentheses:
=IF(Proof@row = "Waiting for Proof", [Proof Start Date]@row + 30, IF(Proof@row = "Family Service Rep", [Proof Start Date]@row + 14))

That worked thank you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63K Get Help
 380 Global Discussions
 212 Industry Talk
 442 Announcements
 4.6K Ideas & Feature Requests
 140 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 305 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!