Add to a date if another column meets criteria

I'm not the best at the complicated formulas and need some help. I have 3 columns in play here. Submission Type (single select), Submitted date (automation added), and Due date (Date Field). If the requestor selects "Standard" in the Submission Type field, then I want the due date to be 30 days after the submission date. If they choose something else, then I don't want the calculation to run. I would like the user to enter the requested date. (I will be using a form for requestor input.)

This is my latest attempt

=IF([Submission Type]@row), = "Standard",(DATE[Submitted date]@row )+ 30))

Obviously wrong since I get an "unparsable" error message.

Could someone help me please?

Find more posts tagged with

Formulas

Automations

Accepted answers

Dale Murphy

@Saavik1 The (first) problem with the formula is a bracket in the wrong place, the one after the first row.

this formula in the Due Date column:

=IF([Submission Type]@row = "Standard", ([Submitted Date]@row + 30), [Submitted Date]@row)

works for me ...

The form should collect a date for Submitted Date only. The form should just ask for a date and a type and do the calculation accordingly.

All comments

Dale Murphy

@Saavik1 The (first) problem with the formula is a bracket in the wrong place, the one after the first row.

this formula in the Due Date column:

=IF([Submission Type]@row = "Standard", ([Submitted Date]@row + 30), [Submitted Date]@row)

works for me ...

The form should collect a date for Submitted Date only. The form should just ask for a date and a type and do the calculation accordingly.

Saavik1

Thank you!!!

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.