-
Work week & calendar days on the same sheet
Hi folks - can anyone tell me how I can have a combination of start/end dates that have standard work week durations (Monday thru Friday) as well as efforts that take weekends into consideration (all calendar days)? I know how to make the Gantt dependencies reflect one or the other but cannot figure out how to make 1…
-
Importing to MS Project
Hello all, Can anyone tell me why when importing an exported plan from Smartsheet into MS Project it places some of the %complete to 99% when it should be 0%? It is really annoying. I am currently trying it on a template plan. Thank you in advance.
-
Please make cells wrap and auto size for multiple lines of text.
Currently if I type multiple lines of text in a task description, for example, the cell will not auto format the row's horizontal size. Thanks. -dave
-
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.