I don't think this is possible but - Is there any way to update a specific string contained in the same field across multiple projects? | Community
Skip to main content
angielawrence
angielawrence
Level 4
March 4, 2021
Solved

I don't think this is possible but - Is there any way to update a specific string contained in the same field across multiple projects?

  • March 4, 2021
  • 3 replies
  • 799 views

For example - we have "Other Project Specific Text" Plw in the same two fields across multiple Projects and users are going in each row (in the Report results or Project list) and manually changing "Plw" to "Pillow". I know this system isn't like a spreadsheet, but does any functionality like that exist to make that easier?

Thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

I don't think this can be done without some sort of add-on, be it Fusion or @Doug Den Hoed‚ 's excel updater app.

3 replies

Heather_Kulbacki
Community Advisor
Heather_KulbackiCommunity Advisor
Community Advisor
March 5, 2021

Hi Angie,

If I'm understanding what you're currently doing, if you already have a report that pulls the fields you want to change, I would use the bulk edit instead of making the change on each row individually.

If some of the projects contain other text in those fields you might consider using a report filter of "field name" contains "Plw" to get just those projects that contain that data in that field, then do the bulk edit.

angielawrence
angielawrenceAuthor
Level 4
March 5, 2021

Hi Heather -

Thank you for the response! We do have a few reports that can isolate the partial text, but we can't use the bulk edit as the full text in those fields is unique - we just need to change part of the field from Plw to Pillow. I know, super strange ask, but seeing if there's a way. Thank you!!!

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
March 5, 2021

I don't think this can be done without some sort of add-on, be it Fusion or @Doug Den Hoed‚ 's excel updater app.

angielawrence
angielawrenceAuthor
Level 4
March 5, 2021

Thank you!!

Doug_Den_Hoed__AtAppStore
Community Advisor
Doug_Den_Hoed__AtAppStoreCommunity Advisor
Community Advisor
March 5, 2021

Thanks for the tag, Skye.

Angie, as Skye mentioned, I invite you to consider our Excel Updater solution which would let you export the date in question, search and replace the values in Excel, then upload the edited data to have it then change accordingly within Workfront.

Regards,

Doug

Terms & ConditionsAccessibility statement

Loading footer...