=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
- 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!