-
Updating a reports format from the related smartsheets
I have a report that looks at 30 smartsheets for current task status. On each smartsheet I have conditional formating to change the complete lines color based on a date field and the current date. When I run the report and I know a line should have chane color but hasn't, I open the related smartsheet and the line color…
-
Archiving Workspace folders
Is there a way to archive folders in Workspace I no longer need in the Workspace drop down?
-
Modify Calendar View?
I'm trying to take a list of dates and associated activities - potentially up to 15 per day -- and display them in a calendar format...either traditional or agenda layout. I have curriculum maps -- material we will cover each day for 6-8 weeks - listed out in spreadsheet format and then want to turn that into something…
-
Suggestions ??? - Menu with links to other sheets
I don't want to get too complicated with my design, but I would like to build a small menu in the upper left corner of my project sheets to help the PMs navigate quickly between sheets (opened and closed). The only snagged I ran into is having a menu on a report that can switch back to a sheet. I'm just adding hyperlink…
-
Indenting in Wrong Column (maybe because of Frozen Columns)
I froze the column "company name" so that it and all the columns before it would follow me across the spreadsheet as I entered data. I am now wanting to indent rows below a couple new headers: "Commitments" and "Prospective" but as you can see in the screen shot below, the "-" symbol keeps showing up in the column just…
-
Duplicate row
Hi, it would be helpful to have a duplicate row kew. This would speed up data entry very much when using similar content of a row, e.g. preparing, holding, follow up a meeting/presentation as three rows. Kind regards Michael
-
Should I have a PM Lite Smartsheet? A One Pager?
This time last week, my CIO asked me to look into Smartsheet. One week later I have a beta version of a project template containing 6 sheets, 3 reports, and one dashboard. I was surprised how easy it was to develop a pretty solid solution in such short amount of time. The beta version of my project template should work for…
-
View Multiple Sheets
Is there a way to view two sheets simultaneously like you can in excel when in View/New Window?
-
Hierarchical List - display and behaviour query
I want to put this in Smartsheet and use the expand and collapse capability. However to get the indented list I need the name and number in the primary data column in SS. That is fine but when I export back to excel I will then not be able to know the 'parent' of an item or its level. The simplest thing would be to do as…
-
Copy/Paste rows changed "created date"
I had to copy and paste a few rows within one of my sheets. When I did, it changed the "Created" date and time to when I pasted the rows. How do you ensure that this column always reflects the proper date, if rows have to be copied and pasted? Thanks K
