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
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 202 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!