When using the Salesforce Connector, there was an unintentional overwrite of cells in a contact column in my Smartsheet table. I have an exported file in Excel which has all the contact names (First a…
I'm trying to track which users are granted access to various systems. What I would like to do is to have one grid which lists all the System IDs (and various properties as columns) with one system pe…
In my sheet I have a column "% Complete" and "Planned FInish". Is it possible to create a formula which can highlight the row color in red, blue or green or yellow if % complete is less then 100% and …
I have a sheet with an auto number column which I expect to get very large. What happens when all the available options for unique numbers are used? For example, once I have already used 001-999, does…
Currently when you want to reference a single cell in another row you cannot convert the cell formula to a column formula without getting a syntax error even though the formula works fine as a cell fo…
I have started to develop a CONFLICT column, that is, a column to show/ highlight where the same ASSIGNED TO/ RESOURCE/ MACHINE has been allocated on the same day, thus identifying potential conflicts…
Our organization uses Smartsheets for cross-functional communication, both internally and externally. However, sharing documents alongside this communication can be challenging. It would be helpful if…
