=IF(AND(NOT(ISBLANK(
Hi,
I am trying to write a formula saying:
- If Forecasted Line Delivery is populated, then apply WORKDAY([Due Date]@row, 0) - WORKDAY([Forecast Line Delivery]@row, 0
- if Forecasted Date is Blank, then copy the value from the cell above
My latest attempt looked like this =IF(NOT(ISBLANK([Forecast Line Delivery]@row, WORKDAY([Due Date]@row, 0) - WORKDAY([Forecast Line Delivery]@row, 0), VALUE([Days between Due Date and Forecasted Delivery Date]56)))), which is obviously not correct
Would welcome any help, many thanks
Answers
-
Try
=if([Forecast Line Delivery]@row<>"",WORKDAY([Due Date]@row, 0) - WORKDAY([Forecast Line Delivery]@row,0),VALUE([Days between Due Date and Forecasted Delivery Date]56))
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!