How to add time or subtract time from a date when "check" is selected?

Hi!

Looking to see if this is possible. I have a packaging release date column that current pulls from another sheet for all items. I have items for Disney that I need to subtract 30 days when I click Disney checkbox column. When I uncheck the checkbox column, I want the date to revert back or add 30 days back.

Here is the current formula for the packaging release date is

=IFERROR(INDEX({WF PKG Release}, MATCH([REFERENCE NUMBER]@row, {Reference number Range}, 0)), "")

I'll then have a new checkbox column to trigger the 30 days.

Find more posts tagged with

Formulas

functionality

Automations

Accepted answers

All comments

heyjay

Can you try this:



=IF(Checkbox_Column@Row = 1 ,
IFERROR(INDEX({WF PKG Release}, MATCH([REFERENCE NUMBER]@row, {Reference number Range}, 0) + 30), ""), 
IFERROR(INDEX({WF PKG Release}, MATCH([REFERENCE NUMBER]@row, {Reference number Range}, 0)), ""))

Shawn_K2

@heyjay THANK YOU! Date changes but is not accurate.

Shawn_K2

@heyjay Ok I need a subtraction. I tried:

=IF(Checkbox_Column@Row = 1 ,IFERROR(INDEX({WF PKG Release}, MATCH([REFERENCE NUMBER]@row, {Reference number Range}, 0) - 30), ""), IFERROR(INDEX({WF PKG Release}, MATCH([REFERENCE NUMBER]@row, {Reference number Range}, 0)), ""))

But the date is subtracting by 3 months.

heyjay

Your formula seems correct. May I know what date are you using and what date is showing when you use the formula.

Shawn_K2

Before check

Checked off. Date is not 30 days before.

Formula

Paul Newcome

Your -30 is in the wrong spot. Try this one instead:

=IFERROR(INDEX({WF PKG Release}, MATCH([REFERENCE NUMBER]@row, {Reference number Range}, 0)) - IF([Column Name]@row = 1, 30, 0), "")

Shawn_K2

@Paul Newcome You the man!!! That worked! Thank you!

Paul Newcome

Happy to help. 👍️

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.