-
Resource allocation not matching project sheet allocation
A member of my team is allocated resource on a project. The issue is that although they are only allocated to 85% on this project/task, it is showing as 100% in my resource view. I only have view access to the sheet and cant change that but am confused as to why this would be doing this
-
Setting a sender out of the contact in the smartsheet
Hello, I am trying to use the smartsheet as a intake form to capture various requirements and make smartsheet to open tickets based on the needs to the corporate ticket system. the corporate ticket form is quite complex to navigate. the tickets are created via emails such as invoice@corporate.com etc. However I would like…
-
Using MAX Formula- How to formulate it to capture infinite rows
Hey Guys! I have a Smartsheet that is connect to Jira. I have added two columns; Created On (with creation date column) and Last Create Date (date column). I am trying to populate a formula that pulls one text box of when the sheet was last updated. When I attempt to enter =MAX([Created On]2:[Created On]???) it wont work.…
-
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…
-
Countifs Multi-select Contact
Hi Everyone, I have a sheet that contains a list of projects. In the sheet I have a column that is setup as a contact column and allows multiple contacts (Project Managers) and a column for project state (State). In my statistic sheet I list all of my project managers(ITPMO ProjectManager) and I want to look back into the…
-
COUNTIFS a range with multiple assigned groups
Hello all, I am trying to COUNTIF a range that includes multiple assigned groups in some cells. I would like to count rows that include "Dept 1". There is one row in particular that contains two assigned groups - "Dept 1" and "Dept 2" - that is not being counted This is my formula: =COUNTIF({Sheet Range 4 - Department},…
-
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
-
Comments
How many characters are allowed per comment?
-
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…