-
Bulk Report Update
Has anyone come across a way to update the criterial for multiple reports at once? We have several reports that all draw from the same set of sheets. Every time we start a new project (and thus create a new sheet), we have to go to each report and attach the new sheet. This is tedious and time consuming. I've even tried to…
-
Dependency Workaround: Linked End Date, Not Duration
I'm linking to someone's Start Date on a project, using the relevant sheet. However, the End Dates I need to track are at the end of a long set of tasks on another sheet - only once all those tasks are completed will this person's time on the project be done. I'd like to link to the very last task this person will perform…
-
Linking information
Hi Is there a way to link folder names and drop down list items to a cell? I could then f.ex. have a sheet with overall Project Info where i list a number of sub projects, then create a folder named through a link to the sub project name in the project info sheet. In the same way maybe i want to assign some sort of…
-
How to make a User Group a Dropdown List
We have created user groups for different departments and have several forms with a column of users. How do we make the drop-down on the sheet pull from a specific user group? Right now we have to manually add/remove names from each sheets' drop down list which defeats the purpose of building user groups.
-
Inactivate a Task
Is there any plan to create functionality to inactivate a task? I'm looking for a way to indicate a task is not needed AND remove it from calculations (schedule, predecessors, % complete, etc) yet still keep it visible (with a line through it) in on project plan. We are forced to make all these edits manually, when it…
-
THANK YOU!!! We can now assign multiple contacts to a column!!!!
Good morning! I just received the email update from Smartsheet Engage 2018 and I. AM. THRILLED!!! We can now choose to allow multiple contacts (up to 20!) to be assigned to a row. See the article here: https://goo.gl/sTwxNZ Blessings, Loann
-
API Access Token for Single Sheet
Hi, I would like to generate an API Access Token for a single sheet. Currently, if I provide my API Access Token in a script for others to use, they can use it to access all of my sheets (and those shared with me). Please let me know how to do this. Thanks, Brent
-
Insert row below - Insert multiple rows above/below
I know that one can insert a row above the current row and there there is a keyboard shortcut for this. It would be nice to have a way to insert a row below the current row as another option for inserting rows. It would also be nice to be able to insert multiple rows at once (above or below), by highlighting that number of…
-
Formula Needed for Parent to Inherit Child Value
I don't think this is possible, but I need a formula where a parent row Status value reads "No Active Projects" until it has a child row below it with an "In Progress" status at which point the cell should just be blank. See image below. I use the "No Active Projects" marker to determine whether or not that department…
-
Apply text formatting to tasks in card view
I would like to be able to, essentially, apply multiple conditions to rows and be able to see them in card view. Currently, I have a condition that changes the task bar color based on a dropdown column. I'd like to also have the ability to apply a text-related condtion (changing the text color to red if the due date is…