-
Row ID
Hi, I would like to be able to return the Row ID of a given column - to use in the following formula: =ROWID(ANCESTORS([Task Name]1)) Which should return the row ID of the first ancestor (Parent) or the current row. If there is no ancestor, I assume it would then return null or 0 Does a function such as 'ROWID' or similar…
-
Templates for Legal Project Management?
Does smartsheet have any plans to add templates for Legal Project Management (LPM)? LPM is becoming a neccesity in the Legal environment and is different from Technical Project Management. Curious if you are looking to add any templates for LPM? Thank you
-
Add a column showing the ParentID (or SiblingID)
Hi all, Is there a way to add a column which displays the ParentID to a Smartsheet? If I had this, I could produce the report I am trying to build I expect. Hep appreciated! Thanks, James
-
Formatting Parent Rows
Is it possible to format a parent row based on the number of children rows under it? If so, could you take it one step further saying like, highlight the parent row green if there are no children rows, yellow if 1 and red if 2. etc Thanks
-
How to compute Average Ratings on a Subset of Rows
Trying to put a formula that will compute the average rating based on organizational grouping. I have a smartsheet that has a drop down field which includes organization functions like: engineering, IT, Sales, Marketing, ... I have another field that is a numeric rating for these organizational functions. 1 thru 5. I need…
-
Templatizing
I have an extensive project plan with 250 sub-tasks, which is maintained separately for every client. As 95% of the task list for every client rollout, and the time allocated to every task remains the same; is it possible to automate this process i.e. I simply enter a start date for the project, and each and every task in…
-
Importing MS Project plans - tasks in wrong order
Hi, I'm new to Smartsheet and just tried to import an MS Project plan. When viewing it I see that some of the tasks are not ordered correctly from the original plan, anyone else experience this or is this a known problem? Thanks Gary
-
Is the row modified date based on the last cell that is updated?
Hello, My question is regarding the smartsheet's row modification date. The documenation only states that it's the "Time of last modification". Is that based off of the last user's cell modification? How is it determined? My goal is to get the user and date that the row was last changed. Thanks!
-
Smartsheet Slow Response Time
The more rows and columns a smartsheet has, the slower its response time. It other words, I am constantly using smartsheet with thousands of rows and columns. As a result, I am constantly waiting for your servers to process and save my work. When can we expect to see better response time? I've posted an image for you to…
-
Rounding
Hi, maybe a simple one: when I enter "0.00000872" into a cell - smartsheet displays 0.00001? How do I get it to display the actual value instead of the rounded value? Thx