-
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
-
Turn on update request replies email
I have a SmartSheet and I regularly send out update requests. When someone responds to the update request, I'm not getting the email notifying me of the update. How do I turn that on/insure that I get the emails? Thanks so much, Janet
-
Use formulas in percent complete column with dependencies enabled
I have a formula in my percent complete column, but when I enable dependencies (in my predecessor column and duration column) the formula gets wiped, leaving only the value behind. Is there a way to keep the formula when enabling dependencies or is this just a limitation of smartsheet?
-
formula to distinguish decimal versus percentage (i.e. 1 versus 100%)
I have a report that combines many sheets. Sometimes the values entered as 1 rather than 100% (or .75 rather than 75%). The report is an input into Tempus (Smartsheet partner) and it makes a difference to their application. Is there a way to determine that a value is NOT a percentage? Or require entry of a percentage, or…
-
Forms Enhancement Request
I would LOVE if Forms could be accessed outside of the sheet. Grouped together the way that Reports, Sheets and Sights are. Is this possible?
