-
I need help creating a formula for identifying task status
Here is the formula I'm using... =IF([End Date]56 > TODAY() + 7, "Future Task", IF(AND([End Date]56 < TODAY() + 7, [End Date]56 > TODAY(), [% Complete]56 < 1), "On Schedule", IF(AND([End Date]56 < TODAY(), [% Complete]56 < 1), "Late", "Complete"))) The formula works to identify Future and Late tasks. How do I update the…
-
Assign To - multiple people
Hi, I'm a new Smartsheet user and am also the Sys Admin and support person here in my institution. After some initial teaching, someone asked about assigning a task to multiple people. I thought maybe that would be Assign To a group. However, something tells me that Smartsheet does not allow assign to multiple people based…
-
Sheet formula to access members in a group
I've created a Group and can track assigned tasks in a Resource View with the group dynamically. Is there a way to access the group list in a formula on a sheet? In my sheet, there is an "Assigned To" column which is a Contact List type column. The cell can be assigned to group members and non-group members. The next…
-
Update email address for contacts does not update shared sheets automatically
Hello all, I have been in the process to update email address for some of my contacts due to the change of domains. However in doing this I realized that all my sheets shared with those specific contacts are not updated with the new information. Let's say that I have already shared or assigned tasks to these contacts. I…
-
Sharing a Folder in a workspace
How can I share a folder with specific people in a workspace while limiting them from seeing other folders in the same workspace? ...It's been over two years since this feature was requested. https://community.smartsheet.com/discussion/sharing-folder-workspace#comment-form
-
adding new users as a group
I need to add over 100 new users and do not want to have to go back afterwards and assign them to a group. Is there any way to create a group first and include them as a group before adding them to the account?
-
Adding Contacts - Logging in for the first time
I'm trying to understand how and when a new contact will receive an invitation to log in and set his or her password. Does this occur when a new contact is added? When a contact is added to a group? To a specific record on a Smartsheet? Any pointers would be helpful.
-
Assigning people to Tasks
Hi, Can you tell me if it is possible to assign multiple people to one task (one column) at the moment I can only assign 1. Thanks.
-
Assigned to limitation
Hi Everyone, Do you know if it is possible to assign the same task to many users ? or a group of user ? Thanks Olivier
-
smartsheet access for more than 1 person at the same time
I use smartsheet for staff to assign themselve to rows (or dates) to cover staffing. When 2 people access the form at the same time they are able to assign themselves to the same date (row) and are both notified that they are assigned for that date. I (as manager) also get 2 seperate emails confirming that each of them…
