IF and OR nested functions for setting Due Dates based on Project Size

Hi folks,

I've been Googling around to try and find some information regarding my challenge.

Basically I need to set up this formula to assign a Projected Due date based firstly on the Date of Submission (Date Column) +5 days for a small project or +10 days for a Large project. I have columns filled through for entry for the project size, a dropdown box within the same row that states whether "Large" or "Small".

I've created this function to handle the IF portion for Small Projects:

=IF([Project Size]@row = "Small", (WORKDAY([Date of Submission]1, +5)))

And this one for "Large" projects:

=IF([Project Size]@row = "Large", (WORKDAY([Date of Submission]1, +10)))

How can I combine these two into a single formula?

Here's what I have tried that returns UNPARCEABLE:

=IF(OR([Project Size]@row = "Small", (WORKDAY([Date of Submission]1, +5),(=IF([Project Size]@row = "Large", (WORKDAY([Date of Submission]1, +10))))

The end goal is to set an Automation reminder for the Reviewer if the 'Projected Completion Date' is passed and the 'Review Completed' box is not set to 'Yes'

Thanks in advance!!

Find more posts tagged with

Formulas

functionality

Automations

Accepted answers

Leibel S

@Cameron Lessey

=IF([Project Size]@row = "Small", WORKDAY([Date of Submission]@row, +5),IF([Project Size]@row = "Large", WORKDAY([Date of Submission]@row, +10),""))

All comments

Leibel S

@Cameron Lessey

=IF([Project Size]@row = "Small", WORKDAY([Date of Submission]@row, +5),IF([Project Size]@row = "Large", WORKDAY([Date of Submission]@row, +10),""))

Cameron Lessey

BOOM, you got it! Wish I could buy you a virtual beer! MANY thanks!

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.