Smartsheet: New Find & Replace, Auto-tracked Web Forms

smartsheet logoSmartsheet online project management software continues to improve user experience and increase efficiency for its customers in how they track and manage their work. Some time ago, it has enabled users to send update requests quickly and add Gantt and calendar views in their reports for greater collaborative work management. Recently, it has released enhancements that save time when updating text in sheets and when collecting information from web forms. Thus, users can spend more time getting work that matters done.

Find and Replace within a Sheet

Smartsheet online project management solution helps project managers structure plans, mobilize resources, support execution, hold people accountable and track milestones, among others. When faced with a great amount of information, updating text can consume valuable time that may be spend on more important matters. The latest release allows users to quickly find text and update it, whether using a PC or Mac platform. The new Find and Replace feature allows users to put in a text that may correspond to a task or date, and then replace it with updated information in one or all occurrences.

smartsheet find and replace 1

Take me to their Website

To use this feature on a PC, just click together the Ctrl and F keys. For those using Mac, it will be the Cmd and F keys. This Find and Replace feature works for sheets and reports. Users can find a particular name of a resource, for instance, and replace it with the name of a person who replaces that resource. Another use can be to find a previously used template and use Find and Replace to change the dates to the current year.

smartsheet find and replace 2

Track Web Form Responses

Smartsheet project management software has the Web Forms feature to help users collect and act on their data easily. These forms are easy to create and customize. They can be used for collecting any kind of information and is great for surveys, feedback or request management. The recent release enables those who created the forms to automatically track names or emails without requiring them to type these details. Now available to Teams and Enterprise plan customers, it is possible to require users to log in first to Smartsheet. Therefore, every user form entry or web response is identified and marked with an email address of a registered user.

Take me to their Website

A benefit of this auto-tracking is that users are not required to type in their names or email address on the form itself. If a user is already logged in, he or she can enter information to Web Forms immediately. If not, the user will be asked to log in first, and then be directed to the Web Form. If the user does not have a Smartsheet account, signing up will be required first, and the email confirmation link will direct the user to the Set Password screen, then directed to the form. To require log in before Web Form entry, the user should go to Form Options when creating a web form, and on the right side, under the Accessible By section, select the option that requires login.

Automating Processes, Reducing Manual Entry

Smartsheet’s new features aim to eliminate the need for extra manual work. There will be improvements and fixes along the way. For example, the Find and Replace feature does not work yet on discussion text, attachment names and descriptions, or in hidden texts. This release, however, also fixed 63 bugs and other customer-reported issues. To learn more about the latest updates, visit their Facebook, LinkedIn, Google+ or Twitter page.



Take me to their Website

Recommended Project Management Software

If you’re interested in learning more about top rated project management software, the editors at actively recommend the following:


Visit website Work OS is the project management software that helps you and your team plan, execute, and track projects and workflows in one collaborative space. Manage everything from simple to complex projects more efficiently with the help of visual boards, 200+ ready-made templates, clever no-code automations, and easy integrations. In addition, custom dashboards simplify reporting, so you can evaluate your progress and make data-driven decisions.

Learn more about

2 ClickUp

Visit website

ClickUp is one of the highest-rated project management tools today. Use Docs, Reminders, Goals, Calendars, Chat, scheduling, assigned comments, custom views, & more with this all-in-one project management tool.

Used by 800,000+ teams in companies like Airbnb, Google, and Uber, it brings all of your projects into a single app! Built for teams of all sizes and industries, Our fully customizable & proprietary features make it a must-have for anyone wanting to keep project management in one place.

Learn more about ClickUp

3 Wrike

Visit website

Tackle complex projects with Wrike’s award-winning project management software. Break projects into simple steps, assign tasks to team members, and visualize progress with Gantt charts, Kanban boards, and calendars. Manage resource allocation and forecasting with software that’s easy to launch. Automation and AI features strip away time-consuming admin tasks so you can do the best work of your life. Streamline your practices, align your team, and ensure you hit deadlines and stay on budget.

Learn more about Wrike

Share Article


Jose Maria Delos Santos Avatar
Get the Free Newsletter!
Subscribe to Project Management Insider for best practices, reviews and resources.
This email address is invalid.
Get the Free Newsletter!
Subscribe to Project Management Insider for best practices, reviews and resources.
This email address is invalid.

Demos, trials & More information

Check out our library of 60+ pm books