Auto copy from one column to another, but only IF...
I'm looking for a formula to copy information from one drop-down column to another automatically, but only if a third column contains a certain word. Is this possible?
For example:
Column 1 could say say "Title" or "something else"
Columns 2 and 3 have a drop down menu of "In progress" and "complete"
If Column 1 says "Title," I want Column 3 to copy the information in Column 2. If Column 1 says "something else," I do NOT want Column 3 to copy the information in Column 2.
I hope this makes sense and someone is able to help!
Best Answer
-
I think this is what you are looking for?
Put this in column 3
=IF(HAS(Column1@row, "Title"), Column2@row, "")
If column 1 has "Title" in it, this will copy whatever is in column 2. If not then it will be blank. If you want it to say something like "In progress" instead of being blank you will put the text in-between the ""
=IF(HAS(Column1@row, "Title"), Column2@row, "Text")
Answers
-
I think this is what you are looking for?
Put this in column 3
=IF(HAS(Column1@row, "Title"), Column2@row, "")
If column 1 has "Title" in it, this will copy whatever is in column 2. If not then it will be blank. If you want it to say something like "In progress" instead of being blank you will put the text in-between the ""
=IF(HAS(Column1@row, "Title"), Column2@row, "Text")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!