Help With Multiple If Formulas
Hi,
I am attempting (Badly) to put together a formula to set dates based on a previous date, but also the timeline is based on a yes or no answer, so if the answer is yes there is one timeframe and if no there is another I also don't want errors if the field is blank. So far I have this;
=IFERROR(IF([Client review Required]@row, "Yes", ([Actual Final Client Approval]@row = "", WORKDAY([Expected Final client approval]@row, 5), WORKDAY([Actual Final Client Approval]@row, 5))), IF(OR([Client review Required]@row, "No", ([Actual Compete date]@row = "", WORKDAY([Expected Complete Date]@row, 3), WORKDAY([Actual Compete date]@row, 3)))),"")
I am getting a syntax error and I can't figure out where I am going wrong...all suggestions very welcome!
Best Answer
-
Hi All,
Thank you for your help i managed to get this to work -
=IFERROR(IF([Client review Required]@row = "Yes", WORKDAY([Expected Final client approval]@row, 5), IF([Client review Required]@row = "No", WORKDAY([Expected Complete Date]@row, 3))), "")
Answers
-
Can you kindly share the structure of the sheet. Or just the column names you have
Parul Mishra
-
For complex expressions such as your case, I would first create an IF structure and insert the contents of the IF structure in a step-by-step manner.
(1) IF Structure
=IF([Client review Required]@row = "Yes", "Approval Date", "Complete Date")
(2) "Approval Date", "Complete Date" w/o WORKDAY()
Approval Date :
IF(ISDATE([Actual Final Client Approval]@row), [Actual Final Client Approval]@row, [Expected Final client approval]@row)
Complete Date :
IF(ISDATE([Actual Compete date]@row), [Actual Compete date]@row, [Expected Complete Date]@row)
>>
=IF([Client review Required]@row = "Yes", IF(ISDATE([Actual Final Client Approval]@row), [Actual Final Client Approval]@row, [Expected Final client approval]@row), IF(ISDATE([Actual Compete date]@row), [Actual Compete date]@row, [Expected Complete Date]@row))
(3) Add WORKDAY() function
=IF([Client review Required]@row = "Yes", IF(ISDATE([Actual Final Client Approval]@row), WORKDAY([Actual Final Client Approval]@row, 5), WORKDAY([Expected Final client approval]@row, 5)), IF(ISDATE([Actual Compete date]@row), WORKDAY([Actual Compete date]@row, 3), WORKDAY([Expected Complete Date]@row, 3)))
Please take a look at the following published sample sheet.
-
Hi All,
Thank you for your help i managed to get this to work -
=IFERROR(IF([Client review Required]@row = "Yes", WORKDAY([Expected Final client approval]@row, 5), IF([Client review Required]@row = "No", WORKDAY([Expected Complete Date]@row, 3))), "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K 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
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!