Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hello! I'm trying to schedule around vacation dates and other non-working days per resource, not for the whole team or whole sheet. How can I block off non-working days for a particular person without doing it 'manually' and messing up the dependencies?
Thanks for any guidance!
Hi mdcatlett
Currently there isn't any option in Smartsheet to mark non-working days at a resource level. This has been a request from the users, but as of now, there isn't any visibility as to when Smartsheet will have this feature.
The only workaround (which is not the best/cleanest) is to increase the duration of the task and make a note that the resource was on PTO, so that you know the reason of the shift in the plan.
I feel that this is a critical feature for any project planning software, but not sure why Smartsheet doesn't think so..
Hi mdcatlett,
This is currently not possible in Smartsheet. Unless you want to create an enormously complex web of hidden columns and formulas, the easiest way to do this is to setup another control sheet with each resource name (as a Contact column) and a Start and End date for non-working periods.
Then in your project plan, you'll want to create a validation column that checks whether the resource assigned to a task row has a non-working period specified in your control sheet that falls within the task date range. The formula might look something like this:
=IF(OR(COUNTIFS({Resource Range}, [Assigned To]@row, {Resource Start}, >=Start@row, {Resource End}, <=Finish@row) > 0, COUNTIFS({Resource Range}, [Assigned To]@row, {Resource Start}, <=Start@row, {Resource End}, >=Finish@row) > 0), "Unavailable", "Available")
You could then use conditional formatting to format the row (e.g. red background) when an "Unavailable" period has been selected.
Not ideal I know and the above formula is tough for newbies to understand, but quite frankly if Smartsheet doesn't allow us to even assign multiple resources to a task, I wouldn't put much hope in the overall resource management piece.
Hope this helps.
Kind regards,
Chris McKay
I want to setup automation for a distribution email list. This distribution email list should be tied to each form request. Do I have to add it to the form or can I add it, somehow, to the responses sheet.
Hello, I have a question about what I'm calling an errant alert. Here is the automation Trigger: When {{XYZ date}} changes to anything + Condition - {{Status}} = Phase 1 - In Progress + Alert someone, send to contacts in a cell = {{AA Assigned}} + Alert someone, sent to contacts in a cell = {{RE Assigned}} The automation…
Hi Smartsheet Community! I would like to ask if having a large amount of data (rows and columns) in a main monitoring sheet can affect the speed or performance of Automated Update Requests. We are currently using Smartsheet for monitoring and have several automations that send Update Requests to assigned users. I would…
