-
Changing outlines of Gantt chart bars
Hello, I would like to change the colors of the outlines/lines around the bars for sub-activities in the Gantt chart. I was able to change the fill color but the outlines are still light blue. Is there a way to change the color of the outlines? Thank you very much! Kind regards Ulrich
-
Project Plan views / Task assignee see's just their tasks
I have read posts where it says to use project plan FILTERS or create one off REPORTS to execute this requirement. This seems inefficient and each option lacks what the other provides. NEED: I want an all in one feature within a project plan where I can set 'resources' view permissions based on when they're assigned a task…
-
How can I select data that is older than 365 day?
How can I select data that is older than 365 day? =COUNTIFS(Product:Product, "ABC", [Project Complete Date]:[Project Complete Date], "Where Project Complete Date is < 365 days from today"
-
Row Attachment: Link (URL)
I use Smartsheet to track video production in my department and there is a request to associate video links (vimeo urls) to each project row. I've tried creating a whole new column containing a hyperlink, but that clutters up the master sheet and its information is not benefitial to sorting or report generating. The other…
-
Time Tracking - Formula needed to total time spent
Has anyone used SS to track actual time spent? I am using the "Time Track for Client Projects" template modified for simple tracking of time spent for individual tasks by client or department. I cant seem to get the formula needed to add the columns for Start time & Stop Time to calculate and provide a Duration for actual…
-
Checkbox checked, cancel RYG
Hello, I have created 3 columns for the RYG, if the project is in the early stages the color green will show, if it is due within 4 days, yellow will show, and when it is due in 2 days red will show. Now I have a checkbox for the employees to click if the work is complete and I want the RYG colors disappear when they click…
-
restrict users from editing curtain fields
Is there a way to restrict certain users from editing curtain fields? For example, we are using Smartsheet so users can enter info waiting for approval, but we want only admin should be able to mark off "check box" for approvals.
-
Alerts/Notifications based on cell color
I would like to create an alert. If a cell turns red in a delivery date column, email PM assigned to PM column and another editor within the sheet. Do not see how to establish an alert just based on change of color.
-
Default sheet opening each time I open Smartsheet
One of the users here at my company asked me a question and I wasn't sure how to answer it. So I figured that perhaps someone in the community may have encountered this question and found a way to make it work. She has a report that I created for her and what she is asking is if there is a way that this report can be…
-
Requirement Traceability
Hi there - We are struggling with some inadequacies with our internal requirements management system and are looking for a workaround or way to leverage Smartsheet for this purpose. Main goals being requirement traceability and bulk uploads. Has anyone leveraged Smartsheet for requirement management and repository…