Days to Launch, stop at Zero

I have created a formula to countdown the days to launch and converted it to a Column forumula so it is automatic for any project. However, we don't need to know the negative numbers or day past launch in this column. I tried nesting an IF function to return a blank cell for anything less than zero but I the dreaded unparseable error. What am I missing?

=[Go Live/Close Date]@row - TODAY(), IF([Days to Go Live]@row, <0, "")

Find more posts tagged with

Formulas

Accepted answers

All comments

Kelly Moore

Hey @Tina Rustvold

Here's one approach to your problem

=IF([Go Live/Close Date]@row>=TODAY(), [Go Live/Close Date]@row - TODAY())

This checks to see if Go Live Date is greater than today's date. If yes, the calculation occurs. If not, a blank will be returned.

Is the Status ever 'Closed' when the Go Live date is still in the future? If yes, you could instead use Status not equaling Closed to drive the calculation: =IF(Status@row<>"Closed", [Go Live/Close Date]@row - TODAY())

cheers

Tina Rustvold

Thanks for that suggestion Kelly; that might actually work better. However, we have Done checkbox that would be the most reliable criteria so I tried the following and got an Incorrect Arguement Set--closer than Unparseable but not sure what the system doesn't like about it.

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.