As a Project Manager I need to assign "Non Human" resources to tasks within my Smartsheet project workflow. Some of my project tasks involve using multiple computers for processing. Depending on the size of the project, it can be anywhere from 15 to 100+ computers being allocated to that task for
This morning I received a note that a shared user was removed by that same shared user.
Clayton Harris was terminated a few weeks ago, but it says he removed himself from this specific sheet. Very alarming! His SSO account was deactivated. It looks like he still had access!
In the Activity Log,
I am just starting to setup a sheet for a huge sports event that shall provide all relevant info, but also be used live to update the onsite status.
Basically there will be about 10 stations that will be identically except for individual timings and some details (i.e. number of people per
Hello, we have a lot of Groups with many members. I need to do an audit of each Group's members to make sure people are in the right Group (we've had some turnover/people changing teams). I am looking for a way to export to Excel each Group's member list so I can easily do that audit. I don't see an
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
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