-
Horizontal Axis Maximum Range
Does anyone know how to alter the horizontal axis range? I have a chart that is displaying percentages but the horizontal axis maximum percent is set to 120% so pieces of the project are looking as though they are not complete. I tried stretching the chart out and making it smaller, nothing works. In excel you usually have…
-
Percentage of certain cells in a column
Probably it's easier than it looks to me, but I'm very new to Smartsheet and any help is highly appreciated. I have a column that contains name of several cities corresponding to complete projects in another column. I'm struggling to put together a formula that will calculate percentage of each city in the whole list. Any…
-
Feature Request - Comments and Attachments trigger 'modified' column value
I'm trying to create reports that will show my projects the changes to their workspaces over the past day. I thought a report would do the trick, and I'd just filter by modified within the last day. However, reports don't always catch what you're looking for, like ALL the changes. Report WARNING, the "modified" system…
-
Last Modify Date based on Comments
I'm looking to see if there is a way to update the "Last Modified Date" system column when someone adds a comment to a row.
-
Clear RYGB balls on completion of a task
Hello, Currently we are using the RYGB balls as a priority indicator. One of the things that happens when you are completed with the task is that you have to clear the ball manually. I would like to automate the task. <Column 1> RYGB <Column 2> is a drop down with the following "Canceled", "Pending" and "Released". I would…
-
Editing a Drop Down List
I am creating a Tasks List and am wanting to use a Drop Down list to indicate the Client the Task refers to. Our Client list is ever-changing. Am I able to add or delete clients from the Drop Down list without affecting the data in the other Client cells? I am hoping to keep the list alphabetical, so additions and…
-
Worksheet Columns
Hello! I'm new to the Community and not sure how to submit ideas for future features, but I'm interested in the following: 1) Is there a way to color-code column headers? 2) Is there a way to group columns into a "section" that can then be expanded/collapsed as needed? These are features I use in Excel all the time and…
-
Feature Request: Ability to @ someone and they get notified
I would love the ability to be able to @ someone when making a comment, and then they get notified in and email that I mentioned them. This would really help when I am making comments and I want people in my team to see that comment (without having to use the notifications feature because it isn't that great because it is…
-
Resource demand, capacity, and utilization management
Hello SS Community! Am fairly new to SS, and was hoping someone might be able to point me to where I might find recommended solutions for resource demand, capacity, and utilization management, using Smartsheet. I know you can use the timesheet template, but it doesn't really do the job of resource management. Thank you!
-
Raise flag if due date is within 30 days
Hi There I'm very new to smartsheet so for you this might be a very simple thing. I'll appreciate if someone let me know what'd be the formula if I want to raise a flag whenever the due date is 30 days from the current date. We'll appreciate your help. Thanks Raashid K
