Match Cell Formula
IF({Project Name} = [Profit Center]@row, {Division}
I am trying to say if the two project names match, populate the division cell.
Answers

Hi Taylor,
The way I understand your formula is that if the Project Name is the same as the Profit Center in the row, then the Division cell is populated.
First, are you typing this formula into the Division cell? If so, where you typed {Division} is actually the 'value item' if your logical expression is true. Therefore, your formula should look like this:
=IF([Project Name]@row = [Profit Center]@row, "value_if_true")
You would place the word or boolean you want "value_if_true" to populate in the Division cell.
Let me know if that helps!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!