Change Dropdown Column Value for Multiple Rows at One Time

Simple question here:

I want to change the Dropdown value of multiple rows at the same time.

Select Rows, 3, 5, 6, and 8. Change these rows' Column B (dropdown) value to "Value X".

Right now I can select multiple rows by clicking while holding shift. But then when I try to change the column value for them all, it just changes the column value on one row, and I have to do each one manually.

Can anyone help me?

Find more posts tagged with

Sheets

Support

Accepted answers

kowal

hi @YeOldeTaylorFarm,

i do not think it's even possible ;(

All comments

kowal

hi @YeOldeTaylorFarm,

i do not think it's even possible ;(

YeOldeTaylorFarm

Thanks :).

Andrée Starå

https://community.smartsheet.com/discussion/139737/change-dropdown-column-value-for-multiple-rows-at-one-time

Hi,

I hope you're well and safe!

Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

1️⃣ - It might be possible to set something up using Workflows.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did I help answer your question/solve the problem? Please support with💡 ⬆️ ❤️, and/or ✅ Answer. This will make it easier for others to find a solution or help answer! I appreciate it, thank you! 🙏

Paul Newcome

If you apply a filter to the sheet to only show those rows you want to change, you can then use a standard find/replace on the column, and it should only impact those specific rows.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.