-
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…
-
Question on multiple predecessors
Hello! When using 2 predessors for one row, smartsheet calculates the later start date. How can I manage to get the earlier start date. For me it sounds like a common requirement. Start as early as necessary to meet 2 alternative deadlines ... Kind regards Michael
-
Changing Colors of Gant Charts
Is it possible to change the colors of the main timeline bars (not just sub-timelines) on a Project sheet in Gantt view? I do not like the grey.
-
How to stop Alerts being triggered by TODAY() formula
Hi Everyone, This is my first post on here and hope someone can point me in the right direction. I have a formula cell which references TODAY() in a certain IF criteria. I also have several alerts going to various users which are generated if cells are added or changed on specific rows (including an alert to myself to show…
-
Row or Record roll up and multiple forms or sheets
I have been attempting set up a relational database for multiple client use. This database should track records (rows including child rows) as it progresses through different phases. Projects may stop periodically and should be searchable and may be re-started later. I have tried using 3 column relational connection to…
