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 t…
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 …
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
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…
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, I…
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…
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 …
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? …
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 …
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