Formula to delete specific values from a multi select dropdown column

Natalia Kataoka

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.

Andrée Starå

https://community.smartsheet.com/discussion/123538/formula-to-delete-specific-values-from-a-multi-select-dropdown-column

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!

Natalia Kataoka

@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.