alter working time
How do I restrict the working time to week days, I don't want the bars to go through the weekends
Task Duration - Partial day at beginning of period, not the end
Hi, I notice when you add a half day duration to a task, it places the half day at the end of the period, for example a start date of 13/11/17 (Monday) with a duration of 2.5 days will result in the half day being on the Wednesday. Is it possible to make the half day on the Monday and the full day on the Wednesday? I'm…
Setting intermittent dates for a single task
I am just getting started with Smartsheets. So far, I am really liking the ease of set up and functionality. One issue I am struggling with is how to set up intermittent dates for a single task. For example, I have a single task where I want to set a date for every other Friday to meet with the client. I don't want to have…
Hello I have been supporting a company in implementing Smartsheet. Successfully :) Today, I'm getting more and more involved in various other important projects and as a result need extra competent workforce to help me supporting our teams. Any interest? Raoul.
Datamesh to Update Engagement Progress for Coaches and Clients
I run a smartsheet for tracking coach/client engagements. There are typically 6 or more sessions in an engagement. Neither coaches nor clients can have access to the sheet. I need the coaches to report the dates of each session in the engagements. Due to the nature of this environment, coaches can report any number of…
Does Smartsheet have an equivalent formula to Excel's TRIM to remove spaces in a cell?
Does Smartsheet have an equivalent formula to Excel's TRIM to remove spaces in a cell? Don't know if it's pilot error, a new feature request, or if there's a work around. Thanks! Eric
Can I see what resources are assigned to from resource view?
I have a resource listed as 300% utilised on a reasonably large project. I'd rather expected resource view to let me click and list the tasks in question, but it only shows the project(s) involved. Despite the various card/project/etc views I also cannot see an obvious "who is doing what today?" report - I can see what is…
#Circular Reference when automating Yes,Hold,No decisions
Hi, Hit a lil road block here. Trying to automate the symbols for my status column based on drop down lists, but i keep getting a circular reference when putting in this formula, =IF([Lead Result]1="Win",Status1="Yes",IF([Lead Result]1,="Negotiating",Status1="Hold",Status1="No")) Posting a screenshot of my sheet for…
Autofill Date Column with Conditional Formatting
Hi there, I am trying to set up an approval sheet. I would like my "Due Date Column" to auto fill a date 3 days before the date in my "Date" column only if my "Completed" check box is NOT completed. Can anyone help me with this formula? Thank you
Linked Cells hindering form entries
Hi, Facing a problem with form entries on sheet with a bunch of empty linked cells. The webform entries go right to the bottom where the links end. The linked cells are important as plenty of info will be added to it in a single day and it becomes quite cumbersome to keep adding new links as we go. Is there a workaround…