Calculation within IF statement

Hello,

I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise compute the variance:

=IF(ISBLANK([Completion Date]@row), "", =NETDAYS([Request Date]@row, [Completion Date]@row))

This returns "#INVALID OPERATION" on the whole column. I've tried the =IF(NOT(ISBLANK variation with the same result. Is there a way to include formulas within an IF statement? Or is there a different way to accomplish my goal here?

Thanks for you assistence!

Geoff

Find more posts tagged with

Sheets

Formulas

Support

Automations

Conditional Formatting

Accepted answers

Jacob Ernst

Hi Geoff,

The "=" sign at the beginning, to indicate a function is being entered, is valid for the entire cell. You do not need to repeat it for each function you enter in the cell. If you change "=NETDAYS" to "NETDAYS" it shoud function as you want.

All comments

Jacob Ernst

Hi Geoff,

GTigs

That did it, thanks Jacob!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.