Formula not populating certain rows


Hi everyone,

I'm seeing an issue where I have a particular formula that moves a date to the nearest business day if the original date lands on a weekend. However, when I drag the formula down the column, it will not populate certain cells. (This is actually apparent across the entire row). Would you know how to solve this?

Best Answer


  • John Teh

    This worked! Thank you, David.

  • David Tutwiler
    David Tutwiler Overachievers Alumni

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!