Multiple IFs in If Statement

Hi there -

I'm creating a simple task tracking sheet, but having trouble formulating the correct formula.

I have a TASK, ASSIGNED DATE, and a DUE DATE. I would like the due date to be dependent on the task at hand - a survey would be due 2 days after assigned, permit comments are due 3 days after, and so on (I have 5 tasks total, with differing lengths of time to complete the task).

Here is my formula, i am receiving an "#UNPARSEABLE" error.

=IF(TASK@row = "SURVEY", [DATE ASSIGNED]@row + 2), IF(TASK@row = "PERMIT COMMENTS", [DATE ASSIGNED]@row + 3)

Find more posts tagged with

Accepted answers

All comments

Darren Mullen

@aecross You have a misplaced parenthesis

Try this:

=IF(TASK@row = "SURVEY", [DATE ASSIGNED]@row + 2, IF(TASK@row = "PERMIT COMMENTS", [DATE ASSIGNED]@row + 3))

Cory Page

You don't need the ) after the if statement starts just add another If statement for "Value if false" section of the statement.

The below worked for me

=IF(Task@row = "SURVEY", Date@row + 2, IF(Task@row@row = "PERMIT COMMENTS", Date@row + 3, IF(Task@row@row = "Task3", Date@row + 4, "Error")))

aecross

@Darren Mullen - that worked, thank you!

A follow up question, I should have included this in the original question, but how can i incorporate the WORKDAY function into this formula?

=IF(TASK@row = "SURVEY", [DATE ASSIGNED]@row + 2, IF(TASK@row = "PERMIT COMMENTS", [DATE ASSIGNED]@row + 3))

Darren Mullen

@aecross You could use that in place of [DATE ASSIGNED]@row + 2 and +3. Or... you could probably use the if statement within the workday function since the if statement returns a date.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.