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
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.7K Get Help
- 474 Global Discussions
- 201 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!