=IF(AND(NOT(ISBLANK(

KarineMul22_TPg
KarineMul22_TPg ✭✭✭
edited 05/07/24 in Formulas and Functions

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

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 05/06/24

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!