Best Of
Business Plan features for a single license
I love Smartsheet's features. When I left my corporate job to strike out as a freelancer, using Smartsheet as one of my primary management tools felt like a no-brainer.
Unfortunately there are some features I want to use (e.g., grouping on reports and sheet summaries) that are exclusive to the business plan, which has a minimum of 3 licenses.
I would be happy to pay the additional charge per year on my license for these Business features, but as a single-person operation, I can't justify paying for two extra licenses that I do not need, just to get these features.
I spoke with an account manager about this, but the only option was for me to pay for 3 licenses and not use two of them. I can't imagine I'm the only user who would love this option, so I'm hoping that Smartsheet will throw a bone to us extra-small businesses out here.
Cheers,
Justin
Calculating Duration - Answered
Team,
It took me some time to figure out how to display duration. I have 3 columns " Date Created " " Time Completed " & " Duration " I have attached an image for refference.
Formula - copy this into the first row of that column. Remember to either rename your columns or change the formula. Cheers!!
=INT([Time Completed]@row - [Date Created]@row) + "d " +
INT(MOD(([Time Completed]@row - [Date Created]@row) * 24, 24)) + "h " +
INT(MOD(([Time Completed]@row - [Date Created]@row) * 1440, 60)) + "m"
Re: Dark Mode for Desktop App
Please implement dark mode for Smartsheet. It is really difficult on our eyes to work on a white screen.
Include predecessor references with copy to another sheet
Sorry if this is already in the forum. I searched and did not see it submitted as an idea. It only comes up in other discussions.
Issue: When using copy to another sheet, the rows do not maintain their predecessor references.
Use Case: We utilize Control Center to provision our projects from a standard "PROJECT TEMPLATE". Each project has about 10 sheets and 10 reports. One of the sheets is a "WORK PLAN", which is a standard project schedule sheet (gantt chart). The "WORK PLAN" template in our "PROJECT TEMPLATE" has a very simple gantt schedule to seed the project. It does not work for most project. It would be too cumbersome to have a schedule in the template that covers every use case. Instead, we have a "SCHEDULE TEMPLATE SHEET" that has about 40 different project schedules (small project, multi phase, multi parcels, SD/DD/CD public work, hydrology projects, landscape projects, civil projects, etc) We would like to be able to highlight the rows we want in the "SCHEDULE TEMPLATE SHEET", and copy to the newly provisioned project "WORK PLAN". Unfortunately, when we do this, the predecessors are left blank in the "WORK PLAN". Some of our schedules have 100's of lines. We cannot simply do a save as from the "SCHEDULE TEMPLATE SHEET" and overwrite the new "WORK PLAN" because Control Center keeps track of each sheets unique identifier. This is necessary should we make system wide changes to our projects. I have also seen the work arounds others have posted (using excel, inserting rows to get then aligned between source and destination sheet, then copy paste just the predecessor info) Frankly, they are cludgy and prone to user error when deployed across multiple managers/teams.
Request: Include the predecessor row numbers (relative) when copy to another sheet. This feature works when copying within the same sheet. The predecessors will update relative to the new row numbers.
Tim Starkey
Re: Join the conversation on STEM education and help nurture the next generation of visionaries
My love for STEM started at a young age with my first trip to Johnson Space Center and meeting some of the first women astronauts. Working with Smartsheet these last couple of years has unlocked my love of technology and I'm thankful my employer encourages our continuous learning.
khickman
Re: Group WorkSpaces and organize them in "folders"
Workspace folders would definitely help me. As someone who creates workspaces for projects and across departments, my list is long.
Resource Management Analytics - Report by User, Utilization/Allocation, and Project
We'd like the ability to create a Utilization Report that groups by Name and then shows the Project Allocation %. We have the ability to group by Team Member but we cannot "Then Group By" Project.
We'd like to see the percentage allocation as a report in Resource Management by the Resource Allocation Plan from SmartSheet. We have the ability to "Then group by" Discipline or Role but we need by Project. "First group by" also does not have Project as an option.
When you view People, on their display record it shows the individual utilization/allocation % but we'd like a bulk report for all the users
January Question of the Month 💭 Join the conversation and receive a badge
Happy New Year, Smartsheet Community 🥳
2023 was a BIG year, and the achievements you shared on last month’s question were nothing short of amazing. You hosted and attended user groups, got promoted, overcame challenges, made time for your hobbies, got married, and so much more.
Now, it’s time to start 2024 with a new question & opportunity to earn badges and points while getting to know your peers.
It’s a new year. What’s one goal you set for yourself?
Let’s bring that fantastic energy of yours into the new year — we can't wait to see what you'll achieve in 2024!
Drop your answer in the comments below. ⬇️
About Question of the Month:
We kick off each month with a new question. These monthly ice breakers are just one way to help you get to know your Smartsheet peers and rack up some badges and points in the process.
Everyone who participates by answering the question prior to the end of the month will automatically receive a unique participant badge once the question closes at the end of the month.
In addition to the participant badge, the top three answers based on Community member votes will receive the Top Answer badge. To vote on an answer click on the upvote icon associated with an answer in the comments below. Multiple votes allowed and encouraged!
Rebeca S.
Re: Adding Images in Form Body and Descriptions
I agree this is a much-needed functionality. Many form builders have this out the box.
Re: Group WorkSpaces and organize them in "folders"
Like this:
~WORKSPACES (as it is called now)
>Department 1
>>Workspace 1
>>>Folders/Sheets/Reports/Dashboards
>>Workspace 2
>>>Folders/Sheets/Reports/Dashboards
>>Workspace 3
>>>Folders/Sheets/Reports/Dashboards
>Department 2
>>Workspace 2.1
>>>Folders/Sheets/Reports/Dashboards
>>Workspace 2.2
>>>Folders/Sheets/Reports/Dashboards
>+ More Departments & Workspaces w/ Folders/Sheets/Reports/Dashboards and so-on...
Sharing/Permissions could be grouped in a tree from the broader Department level to the specific Workspaces within a Department. Then, add the ability to group any of the workspaces that you belong to and organize them into folders inside your own Sheets folder. That'd be awesome!



