Formula Help!!!

Options
Rebecca Wilhelm
Rebecca Wilhelm Overachievers Alumni
edited 12/09/19 in Smartsheet Basics

I can't get this formula to work. Any glaring mistakes?

 

=IF([Date Received at Settlement Desk]1) = "", "", IF([Date of Payment]1 = "", NETWORKDAY([Date Received at Settlement Desk]1, TODAY()), NETWORKDAY([Date Received at Settlement Desk]1, [Date of Payment]1)))

 

Thanks!

Comments