nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Date Formula error

jacquedale

Hi all,

Thank you all in advance.

Hi all, I have successfully used various date formulas in the past but for some reason I am running into a issue with a very simple formula. I am trying to add 14 days to a date (this will end up being a column formula).

Specially I need to add 14 days (which will display in the "forecasted" column) to the "received date". Wen I use the basic formula "=Received@row + 14" I received an error message of "Invalid Column Value"

My screenshot is attached.

Find more posts tagged with

Accepted answers

ShelbyWarren

@jacquedale You might check to see if both columns are Date columns

All comments

ShelbyWarren

@jacquedale You might check to see if both columns are Date columns

jacquedale

Ugh, LOL I knew it was something simple I was overlooking. @ShelbyWarren That did the trick thank you.

Its already been one of those weeks. 🤣

ShelbyWarren

I've been there and done that. Glad it worked out 😀

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.