If Function
I need a formula to assign people to a cell based on a person assigned in another cell.
For instance:
If the cell is assigned to Russ, Tyler or Kirk it needs to say Lauren.
If the cell is assigned to Mason, Bryan or Will then it needs to say Cynthia.
Column name is "Assigned To" and the first name goes in line 2
Answers
-
Hi @Josh Canady,
Try this!
=IF(OR([Assigned To]@row = "Russ", [Assigned To]@row = "Tyler", [Assigned To]@row = "Kirk"), "Lauren", IF(OR([Assigned To]@row = "Mason", [Assigned To]@row = "Bryan", [Assigned To]@row = "Will"), "Cynthia", ""))
BRgds,
-Ray -
It's giving a circular reference error. I think it needs to call out Line 2, correct? I want it to change from Lauren or Cynthia based on the name in "Assigned To" on line 2.
-
Ahh. You are trying to reference a name that exists in the same column. You can't create a column formula to do that. You would have to apply a formula to each row. Otherwise that's the reason for the circular reference (circling back to the same column the formula is in). If you were assigning someone to a column based off who is assigned in another column, then you could use a column formula.
-
Here is how I tested the formula using 2 columns. The formula is in the "Person" column.
-
I can add a column and make it match the name in "Assigned To" row 2. The new column is named "Invoicing". I changed the formula and put Invoicing where you had Assigned to. Just need to adjust the formula a little bit. It is blank at the moment.
-
@Ray Lindstrom I fixed one of my errors and got this to work and wanted to say thanks for the help! Couldn't have done it without you!
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.3K Get Help
- 392 Global Discussions
- 213 Industry Talk
- 447 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 292 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!