-
JOIN Command Issue
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:[Comments #3]1:[Comments #4]1:[Comments #5]1:[Comments #6]1:[Comments #7]1:[Comments #8]1:[Comments #9]1:[Comments #10]1,…
-
Use query strings to populate a contact list dropdown value in a form
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?
-
Can you do if this then that for auto entry from drop down list
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 "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the…
-
Recommend a solution set?
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 modules.... Modules will house the table of contents for topics needing to be covered under each module. There could be a few…
-
Third party person using our company Smartsheet leaves the company will they still be able to login
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 sheets and User is Not added in User Management. Please clarify! Thank you!
-
Assigning tasks through forms
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 menu in the form. Is there a way to limit the options in a form with a filter? Thanks!
-
Missing workspace
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.
-
Doing things first time right with data validation
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 manage "data validation" like excel does. Even with column properties set as Date, users can still write stories "text…
-
Welcome screen URL - using Smartsheet dashboard in Publish
For URL for Welcome screen content, I created 'Rich Text content' and selected option - 'Require User to click 'Accept' in Account Settings. URL is to a Smartsheet Dashboard and I published it, but when I log back into Smartsheet, unless I am the owner - I don't see the Dashboard message, upon login. As I understand, when…
-
Bug: Formula not accurate for Viewer Only
Didn't see an official bug report page, so I hope it's OK here. I've built a formula for a parent row to count orbs in children rows and display red > yellow > green, so if at least one red, the parent shows red, if at least one yellow, parent shows yellow. =IF(COUNTIF(CHILDREN(Progress@row), "Red") > 0, "Red",…