Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

#INVALID DATA TYPE

Pskidmore
Pskidmore
edited 12/09/19 in Archived 2017 Posts

Hi All! I have two cells next to each other, Date Assigned and Date Due. When I add the date assigned date, I want it to auto populate the Date Due as 3 business days in the future. My formula works =WORKDAY([Date Assigned]86, 3) but when I have no date in the Date Assigned cell, the Date Due says #INVALID DATA TYPE. Is there any way to make that go away and just stay blank until a Date assigned is entered? Thanks

 

2017-08-10_13-00-14.jpg

Comments

This discussion has been closed.