How to display a message if no value is entered in a cell?

Options

I have a sheet where there is a column called Actual Start and Actual Finish. I have the following formula providing the difference of "Hours of Effort" based on these two dates.

Formula: =NETWORKDAYS([Actual Start]35, [Actual Finish]35)

However, sometimes the Actual Finish column will not have a date, therefore how do I keep the original formula and enhance it where if no date is entered in the Actual Finish column, then a message can be displayed.


Thanks,

Glenn DeMedeiros

gdemedeiros@dph.sbcounty.gov

Best Answers

  • Glenn DeMedeiros
    Answer ✓
    Options

    Thank you, Andrée Starå!

    Worked as a charm...I appreciate your assistance and support...I hope you have a great week :)!


    Sincerely,

    Glenn DeMedeiros

Answers

  • Glenn DeMedeiros
    Answer ✓
    Options

    Thank you, Andrée Starå!

    Worked as a charm...I appreciate your assistance and support...I hope you have a great week :)!


    Sincerely,

    Glenn DeMedeiros

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!