Formula to delete specific values from a multi select dropdown column
Hello. I have a COI Tracking sheet that tracks insurance by vendor, which includes a multi-select dropdown column that lists all of the job numbers that the vendor needs to supply insurance for. I have one column for Current Jobs, and a column for Expired Jobs.
I have a secondary sheet called Closed Jobs that tracks insurance renewal expiration dates by job number. This sheet contains a check box if the job is Fully Closed.
What I am trying to do is either delete or move individual job numbers from the Current Jobs column in the COI Tracking sheet if the Closed Jobs sheet shows that the job is Fully Closed. Ideally, I would like the expired job number to move to the Expired column, joining the other values that already exist there, but I do not know if that is possible.
Simply deleting this value would be sufficient, as well.
Answers
-
Hi,
I hope you're well and safe!
Do you have access to Data Shuttle?
I hope that helps!
Be safe, and have a fantastic day!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Andrée Starå Yes, I do. However, I am not sure how I would do that as my lookup value and one of the mapped fields would be the same.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!