Exclude cells with no data?

holli.nunn

What function can pull this math but only for cells which have the date in it? I'm just trying not to see an invalid alert on everything - only some projects will have data in the cell referenced for WORKDAY.

Andrée Starå

https://community.smartsheet.com/discussion/comment/437980#Comment_437980

Hi,

I hope you're well and safe!

To add to Brandan's excellent advice/answer.

It looks like he missed the IF part.

Try something like this.

=IFERROR(IF(NOT(ISBLANK(ASR@row)), WORKDAY(ASR@row, 14)), "")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

bisaacs

Hey @holli.nunn,

You can wrap the formula in an IFERROR/ISBLANK function like this:

=IFERROR(NOT(ISBLANK(ASR@row)), WORKDAY(ASR@row, 14), "")

Hope this helps!

holli.nunn

This doesn't work, returns as 'INNCORRECT ARGUMENT'

Andrée Starå

https://community.smartsheet.com/discussion/comment/437980#Comment_437980

Hi,

I hope you're well and safe!

To add to Brandan's excellent advice/answer.

It looks like he missed the IF part.

Try something like this.

=IFERROR(IF(NOT(ISBLANK(ASR@row)), WORKDAY(ASR@row, 14)), "")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

holli.nunn

Thank you @Andrée Starå and @bisaacs for the help!

Andrée Starå

https://community.smartsheet.com/discussion/comment/438115#Comment_438115

Happy to help!

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!