We are making a master sheet to combine all of our 15 intake forms and sheets to help track metrics and more easily send intake rows/projects amongst teams once their portion of the project is complet…
I want to insert a Sum formula into Row 3 that will Sum all the rows in the column beginning at row 4 and continuing to sum any new rows that are added to the column. It seems like it should simply be…
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…