-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
-
Integrating User Profile into Dashboard
Hi, I want to see my project team on the Dashboard (with the profile picture and designation). Can we add Smartsheet users dynamically to the dashboard? thanks
-
CORS in Ionic and third party api(Smartsheet)
I am trying to get data from smartsheet API. When I use postman and nodejs in separate server code, it works. But if I use the API inside the Ionic with HttpClient (@angular/http) it gives CORS issue with run in browser. Failed to load https://api.smartsheet.com/2.0/sheets/1235941564208899972: Response to preflight request…
-
Feature Request: Allow a Comments field for the entire sheet
It would be great if I could look at the sheet properties and have a section to place a comment pertaining to the entire sheet - sometimes it's useful to have a note on the purpose of the sheet and other useful information for users. The comment would apply to the entire sheet not just individual rows.
-
Row sorting
I use smartsheet to keep track of project stages, I have 5 stages of the lifecycle all sorted by a different color. Is there a way to organize the rows so when that stage is reached, the row automatically moves to the bottom of the next section?
-
Hammock task
Apparently Smartsheet does not support the creation of Hammock tasks, i.e. https://support.microsoft.com/en-us/kb/141733 Is there any standard process to propose new features and get them voted by the community? Max
-
Adding Data Rows for Dashboard charts requires reformatting?
I created a sheet to put my data in and created a bunch of charts tied to it. For example, each row represents that week's data. BUT . . . as I add new rows of data for new weeks, I'm finding I have to re-establish the data field for the charts and when I do, I lose all of the formatting for the chart and have to reset all…
-
Enhancement Request: Allow Excel import without formatting
I would like to be able to import an Excel file without formatting. Use Case: I have a customer using an (older?) ERP. The ERP can export to Excel. After row 99 of data, the Excel file changes format. They probably thought that was a feature. I'd like to import the Excel file to Smartsheet without formatting to avoid extra…
-
2-Way Cell-Linking
I frequently link cells because it is very convenient. Could it be possible to enhance this, so that one doesn't have to use "Go To Sheet" in order to update the value? In other words, can we have 2-way linkage, so that if it's updated in either place, then the value has been updated? I constantly have to go to source…
-
One task split into multiple periods
Hi Smartsheet! I have used Smartsheet at my former job and have now recently switched job and am evaluating what PM tool to use within the new company. The overall experience from working with Smartsheet has been positive but the tool however has one very critical shortcoming as I see it (at least for how we wanted to use…
