If Formula Cross Sheets

Having trouble connecting my IF formula across 2 sheets. I am getting an #UNPARSABLE error. All columns are text columns.

If the column has Mark's name, then = 100. If the column has Tim's, then = 200.

=IF({TRACKING SHEET Range 1}@cell = "Mark", 100, IF({TRACKING SHEET Range 1}@cell = "Tim", 200)))

Find more posts tagged with

Accepted answers

All comments

Paul M Kahl

Looks like the formula has an extra right parenthesis.

=IF({TRACKING SHEET Range 1}@cell = "Mark", 100, IF({TRACKING SHEET Range 1}@cell = "Tim", 200))

aecross

Hi @Paul M Kahl - thanks for the help! I am unfortunately still getting an #UNPARSABLE error.

Paul M Kahl

Apologies, I wasn't paying attention to the reference to another sheet. Maybe you can attach an image of the two sheets?

aecross

Paul - these sheets both are very sensitive information so I do not feel comfortable sharing images. However I'll explain my columns more clearly.

I am trying to populate my Estimate OSC column with Mark and Tim's outside costs. If the Partner column (in the referenced sheet) is Mark, then = 100. If it is Time, then = 200.

But, regardless, it is always one or the other. So maybe a formula that is just if the Partner column (in the referenced sheet) is Mark, then = 100, otherwise it equals 200. I've tried to set this up and couldn't quite get the right formula.

=IF({TRACKING SHEET Range 1}, ="Mark", 100, 200)

Dakota Haeffner

So you have an extra comma in your logical expression.

=IF({TRACKING SHEET Range 1} ="Mark", 100, 200)

however this formula still probably wont work because you are asking it to look at a range of cells, right?

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.