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.

Hide formula error message

Hi, I have set a formula up to add 7 working days to a date: The date is added once an action is completed.

=WORKDAY([Date]1, +(7))

If the source cell is empty I get the error message

#INVALID DATE TYPE

Is there any way to hide or remove the error message.

Thanks Hugh

Comments

This discussion has been closed.