Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for October 2017
Discussion List
Suggestion: Moving sheets into a workspace
It seems that a user cannot move a sheet into a workspace where they are not the Owner, even if they have ADMIN rights to that workspace. It would be useful to have that capability.
Suggestion: The Metric Widget should count items in a column
For example, if I have a dropdown of all 50 states, I should be able to set up a widget to count the number of times Alaska was selected, simply by selecting that column and one of the selectable options. If 20 people have selected Alaska, it would read 20. When a 21st person selects Alaska, then that widget would read 21.…
Question about sorting
Hi, i'm looking for some suggestions on an issue that I am seeing related to sorting in one of my Smartsheets. I have a sheet that has a row with instructions to the users as the first row. I have a checkbox column that is only checked off in the instruction row, and I use a sort to keep this at the top of the sheet. My…
Enhancement Request: Rules for Manual Update Requests
Now that we can create rules for automated update requests (and BOO! that it requires a Business license. Boo! I say!) it may be more feasible to add rules for manual update requests. Selecting 3 columns out of 50 is a pain in ass (ie time consuming). Retyping the message is also annoying. What I want is to set up Manual…
Feature Request: Surrogate Update Requests
I would like the ability to have an Owner or Admin create an Update Request rules and change the person who receives the UR Sent and UR Submitted feedback emails (ie, the 'sender') This would allow one Admin to set up a project sheet and associated Update Request rules that are then managed by another user (non-Admin) As a…
Combining IF/IF AND Statements
Hello! I cannot seem to figure out how to put together two working IF and IF(AND...) statements. Thank you for any direction on how to accomplish. Sandy If I put "IF(AND..." in front of all the IF statements, only my first two statements work. The rest are ignored. If I remove the "(AND..." from only the first two…
Export the smartsheet to microsoft project
I tried to export my smartsheet to Microsoft project and save the file there. But I did not find export button. For the trial user, do I have access to this function?
Passing values from a report
I'm trying to create a Sight that shows a high-level overview of a portfolio of projects. If the user clicks in the widget within the Sight I'd like them to go to a more detailed report on the project that they selected but only the project they selected - not all the projects in the sheet. Is this possible? Thinking of…
Switching from licensed user to regular collaborator
We have a licensed user who no longer needs this level of access, so I want to switch her to the regular collaborator. If I do this will this effect any of her sheets that she created until the license user level? Or will she retain all of these and then just be limited as she moves forward? Thanks
IF statement help to determine active sprint
Hi all -- just starting to build a library of IF statements... Looking for some help to build an IF statement to determine which Sprint is the current active sprint... Basically, IF Today's date is between [ColumnSprintStartDate] and [ColumnSprintEndDate] then check the box, if the date is not between those, then leave it…