I am part of a PMO and we track all projects on one sheet. The PMO covers multiple lines of business within our organization, thus I have a Sight set up per line of business. In each Sight, I would like to be able to show the number of projects in each RYG status. What is your recommended approach for doing this? I've been…
I have a sheet in a workspace that I want to send as a PDF attachment on a reoccurring basis via email. When it sends - it is FROM "my name via Smartsheet" and then user@smartsheet.com. I want it to come from another name - not my name. Is that possible? I assume it is if I change my name on my account it will do this…
I have an assessment sheet where 2 different rating columns are linked to the rating key at the top of the column. Would it be possible have the Rating Key Sheets linked or formulated so that when a rating is selected on the key, it'll enter it into the cell on the Assessment sheet? Does anyone have any suggestions / best…
When my smartsheet is open and I am not doing any editing, I find that cells mysteriously empty themselves and are marked as changed. The RYG balls also just disappear in the priority column and are marked as a change. Sometimes it is impossible to restore the information as it keeps reverting to being deleted. Only one…
Is there a way to freeze the top 2 rows of a SmartSheet? I have data in the 2nd and 3rd row that corresponds to the header and I'd like to maintain visibility but have yet to find a way. Thanks!
I need to create a count of 1-10 that always stays at the top of the column in the correct order even when the sheet is sorted and when web forms are used to input information to the top of the sheet. Sounds simple but I have no clue how to do this without drawing a circular reference and without the ability to reference a…
When dragging rows to another sheet, is there a way to keep the information from the Parent sheet which to information is being pulled from? This would obviously automatically create linked cells back to the parent sheet that the information is dragged from. Is this possible? Current Process: My company is basically trying…
Is there a way to select specific columns for displaying on alerts? Currently all columns display on the alert including a column that I have for my own use. Thanks, jerry
I am sure that most of you have a list of things that you would like from Smartsheet. I have a short list to get us started. Lets add to this and see if they can make it happen! 1 - Ability to paste more than 50 rows at a time. * 2 - Extend the 5,000 row per sheet limit. * 3 - Ability to create a new sheet based off of a…
I would like to have the % completed set automatically to 100% when the Task Finished is checked. Any suggestion on how to do that? First smartsheet struggles...