Auto Fill a row from another row
I am trying to autofill a row with a specific number when a certain drop down in used in another column but I am getting an error. I am not seeing an Automation or a conditional format that supports this so I am assuming that this will require a function but I am not able to figure out which one.
IE- When FY23 is chosen under project name, I want Account Number to auto fill account number 123-456-789 and when FY24 is chosen I want account number to auto fill 987-654-321
Can anyone assist with this one?
Minni Florence
Senior Project Coordinator
Industrial Properties Construction
Best Answer
-
Try this -
In your Account Number (CPR) field, use this formula:
=IF([Project Name]@row = "FY23", "123-456-789", IF([Project Name]@row = "FY24", "987-654-321",""))
If you have a lot of values, you may want to consider a reference sheet and then INDEX/MATCH into that sheet.
I hope this helps you. Have a great day!
Ramzi
Smartsheet Solutions Architect
www.adapture.com
Answers
-
Try this -
In your Account Number (CPR) field, use this formula:
=IF([Project Name]@row = "FY23", "123-456-789", IF([Project Name]@row = "FY24", "987-654-321",""))
If you have a lot of values, you may want to consider a reference sheet and then INDEX/MATCH into that sheet.
I hope this helps you. Have a great day!
Ramzi
Smartsheet Solutions Architect
www.adapture.com
-
@Ramzi You are my HERO!!! Thank you so very very much!! It worked!!
Minni Florence
Senior Project Coordinator
Industrial Properties Construction
-
Happy to help!
Cheers,
Ramzi
Smartsheet Solutions Architect
www.adapture.com
-
@Ramzi I had it all set and someone at some point went in and messed it up and now I am having an issue with using multiple IFs in the same cell. Can you assist?
Minni Florence
Senior Project Coordinator
Industrial Properties Construction
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!