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)))
Answers

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))

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

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

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)

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?
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 63 Global Discussions
 66 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!