How to create a deadline column for it to be three days before the deadline that was put in the form

I am trying to create a workflow (I think) that when someone completes my form and enters their requested deadline in the form, there will be an automatic column that will show three days before that deadline requested. I want that date to automatically show three days before the requested deadline so that we can get enough time to have approval from our managers and make any changes to what is being requested before the requested deadline.

Basically, how do I have a column to automatically show three days before a requested deadline?

Find more posts tagged with

Forms

Formulas

Marketing

Workflows in Smartsheet

Accepted answers

All comments

Andrée Starå

Hi @Micah Sheerin

I hope you're well and safe!

Try something like this. (and make it a column formula)

=[Requested Deadline]@row - 3

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

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.