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…
When leaving Friday afternoon all of our sheets and our workspace was working fine. Came in this morning to find all of our sheets / work space totally gone.
In a productive organization, the most efficient method for cutting waste is to attack anything and everything that is not done right the first time. The only drawback to SmartSheet is its ability to …