Smartsheet is missing the ability to use a wildcard (*) in it's functions. This is a valuable tool and would be incredibly helpful, please add this functionality.
Sign in to see the current vote count, add your own vote, or leave a comment.
100% agree using find / contains is painful.
100000000% agree
I want to echo Samuel Mueller’s request for the addition of wildcard functionality (e.g., *) within Smartsheet formulas. The ability to perform partial matches is fundamental in many spreadsheet use cases—especially when working with large data sets or performing flexible lookups and filters.
*
Currently, the absence of a wildcard function limits the efficiency of many workflows. This is a basic yet powerful feature found in other platforms like Excel and Google Sheets, and would be a valuable step forward in expanding Smartsheet’s formula capabilities.
Looking forward to seeing this implemented!
Re-upping this - this functionality would be very helpful to have.
Most customer's metadata houses their profile data, some from intake sheet and some either cell linked in or brought into metadata using formulas. Needs change after design and often the new data point needed comes from non-metadata templates, which can cause a blocker if methods used are those above. If it were possible…
Our sheets & workspaces require many people to have Admin level capabilities, which means that when someone requests access to a sheet or workspace, that email is sent to every Admin. This causes confusion and higher risk of no access granted (because people have learned to ignore the emails) or the wrong level of access…
Today you can create a form and add logic. If that logic requires that requests need to be made for X days in the future you can add logic to help. For instance is the date requirement is not met you can hide fields so that information cannot be submitted completely. You can display a banner if date requirements are not…
