-
Will we ever be able to assign a task to multiple resources?
Is there any update on when this feature will be implemented? I cannot believe it is still not possible to assign a task to multiple resources. We are going to need to move to another site soon if this issue is not resolved. It seems crazy that after 12 years, this essential feature still does not exist, while something as…
-
Multiple people assigned to one task
If I have multiple people assigned to a task, could I create two "assigned to" columns (each with a slightly different name) and still use the notifications and reminders without issue? That would prevent me from having to create two duplicate tasks when I want to assign to multiple parties.
-
Report view without access to underlying sheet
We are attempting to create a report view that is a subset of rows driven by a column flag. We have found that the report viewer will also have access to the underlying sheet with all of the details. Our goal it to provide a highlevel summary via the report and restrict access to the subtask details.
-
Counting total specific drop-down option between 2 dates
Hello! The sheet that I am working with is used to track agreements my department works with. Two of the data points (among many) that we capture is the agreement type within a drop-down and the signature date. I would like to capture the total "Amendment"'s from the drop-down list with a signature date that fall in our…
-
Publish Calendar to display working days only
I have a project that covers 3 months with 4 people traveling to various offices. My calendar indicates their locations throughout the months. I've defined Working Days, Non-working Days, and Holidays on a Project Sheet, which reflects correctly. However the calendar view indicates that the persons are in the locations…
-
Best way to set up a sheet to track multiple IT projects
Our IT department has several projects we want to track. I need advice on the best way to set up the sheet(s) so that we can see the details of each project and have the ability to see all of the projects on one sheet. Which option would be the better set-up? Option A - Have one sheet that lists of all the projects with…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Calculating complete dates with calendar days but....
I've brought this up before and at one point I thought that I found a great work-around. I would like to use calendar days in my date dalculations but, not have an end date land on a weekend. I created a complete column and with the use of a formula I tested the end date for a weekend and if it was a weekend I boosted it…
-
Formula help - if cell range contain any text, check the checkbox, otherwise uncheck
Hi All, I'm new to Smartsheet and was hoping someone might be able to help. I'm trying to build a formula where if a range of cells with that row contain any text, a checkbox is checked. But if anyone of the cells in that range has not been filled out, the box is not checked.
-
Alerts not Sending to Assigned To Column
I want to send a daily reminder listing open tasks to contacts listed in my Assigned To column. All contacts have been shared to the sheet as Editor - cannot share. At least a couple of these contacts are users who have used SmartSheet before. I set a conditional formula in a reminder date field to populate with today's…
