Has anyone found a practical solution to match a Contact column to an email address? It can't be done in DataMesh and while I've done some searching on the board and help files, I haven't found a meth…
A department wanted a way to take a unique list from a project column in one sheet and use that distinct listing as a dropdown for another sheet, which updated every hour. I currently run the below sc…
Greetings! I have successfully installed the Smartsheet Outlook connector for Office 365 (desktop). Upon opening a received email the Connector tool is visible and works properly. However, when I crea…
I'd like to allow users to update information in a row via a Form. I like the user interface of the Forms and would prefer to keep users away from the spreadsheet. I know about locking information in …
Hello all, I have dug around enough to be certain that there is no feature to restrict a column to a certain data type (i.e. restricting a text/number column to only be 6 numeric digits). This is some…
For my project - I want Control Center to recreate sheets that have certain automations linked to it. These automations copy/move rows to sheets in the newly created project folders. However, when a n…
Hi all, I've read a few solutions on how to do this but just can't get my head around to apply it to my own sheet. I have an incident register that we are moving into smartsheet and one of the columns…
I realize there is currently no smartsheet function equivalent to the OFFSET function in Excel. (But it would be REALLY nice if there was one!) Until that particular enhancement request is finally ach…
Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data.