-
Time Tracking
I'm new to SmartsSheet and don't see an obvious way to track time, and have it recorded against a task Personally not too fond of % complete - to often I've seen people say/think (legit or not) that they're 90% done, and the last 10% takes as long as the first 90% (or, unfortunately, more) People often think they're almost…
-
% Not showing on Report
I have a sheet that shows a number converted to % (i.e., 51%), but on the report it is displaying as 0.507 with no option to transform the number to percentage. What am I doing wrong?
-
Surface row report data to dashbord
Is there a way to surface a contact from a row report to a dashboard? When I go to add using a metric the row report is not accessible. I note that the row report is accessible to surface data for a chart. What am I missing/not doing?
-
Any templates or sample of multiple project dashboards?
Our small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project. Most of the reports and dashboards I've tried to create capture a single project but I'm not finding a nice way to show multi-project…
-
How do I remove a row from a report?
bonsoir, ligne 7 ici ?
-
Report - using the Summary option by Count, when the cells are blank it groups by blank but does not
Reports - using the Summary option by Count, when the cells are blank it groups by blank but does not count the blanks and displays '0'. I have about 200 rows that have a null value in the column I am summarizing, but the count is displayed as 0 (zero) instead of 200. How can I get the report to count the blanks?
-
Can I add an additional layer of nesting to my report builder filter?
There are 5 filter option right now and I need it to look like: [ Condition 1 AND [ [Condition 2 AND Condition 3] OR [Condition 4 AND condition 5] ] ] Is this possible? I need one more layer of nesting to combine the 2 inside ands to have an or on the outside, while keeping condition 1 and those 4 nested together. I hope…
-
Smart Sheet Summary for average time between two dates for two columns
Hi all, I am having some issues working this one out and am hoping someone might be able to help! I have two columns in my sheet that I am interested in, "Predicted UAT Start Date" and "Actual UAT Start Date". I then have many rows for each of our different projects. What I would like to know is the average amount of time…
-
OFFSET function equivalent?
I realize there is currently no smartsheet function equivalent to the OFFSET function in Excel. (But it would be REALLY nice if there was one!) Until that particular enhancement request is finally achieved...I need help finding a workaround. My situation: I have a sheet of data where the columns contain individual employee…
