-
2 week task for 2 hours each day
Is it possible to have a task with a duration of say 2 weeks, but only allocate a fraction of the day’s hours to the assigned resource? For example, John Smith is assigned Qlik development that will last for 2 weeks, but will only be developing for 2 hours/day. I know it’s possible to change the default length of a day…
-
Totals By Date
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/15/18 Completed 2/16/18 2/20/18 Cancelled Output: Total 'Completed' for January 2018 = I'm wanting to use the dates and…
-
Filtered Views for External Collaborators
Hello, i am not sure what the best way is to accomplish this. I have a smartsheet that i would like to collaborate with outside vendors. I would like to avoid chopping up the data and giving every vendor their own sheet. I will be adding new data weekly. Update request won't work because they could be getting 20+ lines at…
-
Resources allocation / staffing at hourly granularity
Hi. we have the need for a tool that will allow us manage short & simple projects (hours/days) for our team. Something like Float.com. As we are using Smartsheet already, i'd prefer to find a solution that utilize SS, instead of bringing to the company another solution. But - I didn't find a way to work on an hourly basis…
-
Need help with a recurring report formula
Hi. I am new to Smartsheet and it has been a while since I have done alot with formulas in Excel. I am setting up a report tracker for our organization that will have recurring reports due on a weekly, monthly, and quarterly frequency. I need some help with a formula to automatically adjust the next due date so that…
-
Calendar View
My conditioning format does not show when I view my smart sheet in the "calendar view". Any suggestions?
-
Having link to Smartsheet on our intranet
Hi all! I work in the Communications department and we keep a tracker of all of the events for the year. It used to be an Excel spreadsheet and we put a link to it on our Intranet page for all staff to access. Now we keep it in Smartsheet, and I've only given access to my team. Is there a way for folks outside my…
-
Checking what Months are during a Project
Hi, I've tried to find a solution for this, but maybe it's a too generic wording problem. We have a Master Project list, that has the start and end date of every project we have, as well as it's budget and projected profits. I want to have an overview of how much money is allocated to each month and for that I need to…
-
This rule triggered itself directly or by at least 1 other rule, which is prevented.
I have a SmartSheet constructed as follows: 1. A dropdown list contains five options to indicate the task status (Column = "Pickup Status"). Pickup Status Pending... Pickup Now Do NOT Pickup Pickup Completed Unable to Pickup 2 . The Foreman will use a form to submit the initial data and set a hidden field to "Pickup Status…
-
SUM Function
I am trying to calculate Percentage Complete on a task (Project). I know the Percentage Left (that calculation is working perfect), but the Percentage Complete works on one sheet and not another. =SUM(1 - [Percentage Left]4) On the next sheet I try the same thing and all I get is the return of the function syntax. Any…