-
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
-
Indent or minimising rows
Hi, I have several standard grid sheets that are populated via webforms, we are based within the UK. The issue I have is that I don't seem able to include "indent" function to the rows (i'd like to indent per month), as the sheets are growing huge as we have a lot of data being submitted from remote and field workers. So…
-
Formula help - due dates falling on weekends
I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays. Now, I want to move those dates to the Monday next. Is there a way to automate that? Ultimately, I need the best way to…
-
Direct entry of images in to row cell of a Project Tracker sheet using FORMS
hi I am trying to develop Project Progress tracker wherein I intend to get my construction site photos in to my progress sheet using information update by way of a FORM. My current challenge is that I can get photos uploaded through form but they get located in comments tabs and for every time I have to first manually…
-
Aging Date Average
Hi Community, I am attempting to create a KPI for a dashboard that will capture the average number of days a 'something' has been opened, but only if it is still in an opened state. I can perform the appropriate "days open" with "=IF([Closed Count]3 = 1, NETWORKDAYS([Submitted Date]3, [End Date]3), NETWORKDAYS([Submitted…