90 Days Prior to a Target Date Formula

Jonna Critchley

Hi There,

I've reviewed the forms and found a formula that seems to work for everyone but me:

=[Target Submit for Comment Date]@row - 90

I get Invalid Column Value error.

I just need to calculate 90 days before a specific date - how would I go about doing that?

Thanks!

Find more posts tagged with

Accepted answers

Blake Neyland

If you go to "Column Properties" of the column where your formula is and change the type to "Date", this formula should work just fine (it did for me a few minutes ago).

Blake Neyland

https://share.vidyard.com/watch/KxrjAdqFKerDoZwvANUnns?

Here is a screen capture of the process.

All comments

Blake Neyland

If you go to "Column Properties" of the column where your formula is and change the type to "Date", this formula should work just fine (it did for me a few minutes ago).

Blake Neyland

https://share.vidyard.com/watch/KxrjAdqFKerDoZwvANUnns?

Here is a screen capture of the process.

Jonna Critchley

THANK YOU!!

lmlearning

@Blake Neyland , how about if I wanted to use the above formula but not for the entire column just the ones that are marked as "New" in the another column?

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.