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!
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…