An employee retired without transferring his sheets and reports, that are in various workspaces and folders, to me. How do I keep the sheets and reports in the same workspace and folders while transfe…
Hi everyone, someone on my team brought this to my attention and i want to see if anyone else has experienced this. I have a sheet where the 90% of the data is entered via a form. the remaining 10% of…
How do I formulate a percentage in cell "Total Percentage" using division formula based on data from "Total Score" cell? The "Total Score" cell correctly shows a result of 43. What I want to do is div…
Getting a #unparseable error with the following Join command below. I want to combine ten different comment cells and join them under another separate Comment cell. =JOIN([Comments #1]1:[Comments #2]1…
Is it possible to pre-populate a dropdown field in a form with a query string value when the values of the dropdown field are set to contact list and have a pre-defined set of people?
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "current…
Hello Community!! I am attempting to build a solution set for an internal training/learning organization who has to go build very complicated trainings for technical staff. Each agenda will contain mo…
We share our sheets with outside company people to collaborate. If this company person leaves the company, will they still be able to login to Smartsheet and access our sheets? The sharing is done by …
Hi, I want to create a form that limits the selection to unassigned tasks from a master task list. The task columns is currently the primary column, so there is no limitation to create a drop down men…
