Days to Complete Formula for Specific Criteria

Hello all!

I am struggling with a formula for 'Days to Complete'. I have a sheet from a template that previously had this formula for days to complete:

=IF([% Complete]@row < 1, "N/A", [Actual Delivery Date]@row - [Date Requested]@row)

The sheet has been updated and customized and the [% Complete] is no longer relevant for the formula. This new sheet only includes completed work moved from an active sheet. I need to determine this formula for days to complete now based on the column [Campaign or Project Required] not being blank. I've looked up formulas relating to not blank for the first portion of the formula but am having trouble. I appreciate any advice.

Thank you!

Find more posts tagged with

Accepted answers

Michael Culley

So I believe you're looking for

if([Campaign or Project Required]@row <>"",[Actual Delivery Date]@row - [Date Requested]@row)

All comments

Michael Culley

For not equaling blank you can use something like if([Campaign or Project Required]@row <>"","Do this","Do that")

Michael Culley

So I believe you're looking for

if([Campaign or Project Required]@row <>"",[Actual Delivery Date]@row - [Date Requested]@row)

Lorraine Stevens

@Michael Culley Thanks so much! I had to add a few spaces and it worked perfectly! Much appreciated.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.