-
Merged: A cohesive/real-time ability to work with multiple people within a sheet at the same time.
This discussion has been merged.
-
How do I use percentage formulas to breakdown responses
I am currently tracking a project and have 4 columns that use the following values - pass, fail - see notes, n/a, not tested. How can I break this down % wise to see which line items have passed, failed, n/a or not tested per column? The goal would be to roll the information up to a report then up to a dashboard.
-
Keyboard Shortcut to Hide Column/Row
Instead of having to right click and navigate the cursor to hide a column/row it would be ideal to have a keyboard shortcut to assist. i.e. right click on a column that is to be hidden and hit the letter H on the keyboard to hide the column. Same concept can be applied to a row.
-
Combine: IF AND CONTAINS, And SUMIF
Hi, I got a question about how to use all the above statements in one formula, _______ I have the following columns; A regular text column "Client ID", A multiple dropdown column "Shared IDs", A regular text column "Hours worked" A regular text column "Shared Hours Approved" _______ I have each client and their Client ID…
-
Add Column for Date Record is Closed
I want to create a new column that is a formula. The Status can be blank, Open or Closed. Once a record is closed it will not be reopened. If there is reason to do so, a new record will be opened and it will reference the original. This has only happened once. This date column should be blank unless the status of the…
-
Transfer ownership of Smartsheet items
We created a workspace and made our client (from different organization) the owner, but there are still several sheets, reports and dashboards that are under our ownership. We are not a licensed user anymore. Is there any way for us to transfer ownership of all items to our client (without having to do it one by one for…
-
Transfer ownership of Smartsheet items
We created a workspace and made our client (from a different organization) the owner, but there are still several sheets, reports and dashboards that are under our ownership. We are not a licensed user anymore. Is there any way for us to transfer ownership of all items to our client without having to do it one by one for…
-
Cell Linking to Wrong Sheet When Provisioned
In our blueprint in Control Center, we have added a new sheet that has several cells linking in from another existing sheet. In other sheets/projects, the cell links update so it links to the new project sheet when the project is provisioned. However in the sheet we just added to the blueprint, the sheet is created just…
-
Enhancement Request
Hello, I have a few requests that would enhance my Smartsheet productivity that may be useful to others as well. Please redirect my post if this is in the wrong area since it has been a while since I've posted if at all. I understand that some of these features may be available in the premium add-ons that Smartsheet…
-
Merged: Required Fields in Automation Workflows
This discussion has been merged.
