-
Feature request: Enter formula in report
I know that Smartsheet does not currently support creating formulas from a report. Any formula manually entered in will display as plain text rather than performing a calculation. I am not sure how the would work, but it would be nice to have a way to enter a formula into a report and have it calculate. I envision this as…
-
Using Report builder to find past due 'Days' tasks
I have a sheet that lists bugs and it has a 'Created Date' column (not a system column, just a date column). I need to generate a report of all issues that are 'Open' and 30 days old. I can check for 'Open'. But I wasn't able to find a way to check for 30 days old in the report builder. Can I do this just using the report…
-
Post Trial Review of Smartsheet as an IT Project Management solution
I've been assessing Smartsheet as a viable replacement for MS Project at our office over the last 30 days and I thought I'd share my finding with the Smartsheet community in case somebody else is also doing such a review. I'd also invite Smartsheet to respond to my observations if they feel I've misrepresented anything…
-
Feature Request: Complete Update Request from within SS, or Refresh UR, or Edit UR
I send out dozens of update requests daily to people and yes some of them slip through the cracks. This is natural, as many people (myself included) set up filters for their incoming mail and don't always see them in a timely manner. As such, if I tell people to go through Smartsheet and check for their open update…
-
dropdown menu in a column in webform
hello everyone i am brand new user in this community trying to familar with this software. so far looks very promising. i have a question like how to make multy forms in one web form like i want to generate form in which in second line there should be multy option to select one and then under neath line will change…
-
#Invalid data type in a report
Hi, I want to run a report with the following conditions: Compile report on days overdue column= "#INVALID DATA TYPE" I have inserted rows with days overdue = #INVALID DATY TYPE but it doesn't pull through. Please assist. Y
-
Reports - improve options
Reports needs improvement. I like the idea but can't i report to a graphic or a bar graph or something like that? The report filtering is hard. For example, i want to filter to the high level tasks like and not all the detail. To do that i have to filter using another column to select. I should be able to report on a few…
-
Sorting recommendations when you have summary rows on the top on your sheet
I am experiencing issues when sorting a sheet and have summary rows at the top. For example, I created summary rows on rows 1 through 10 with formulas and totals, and when sorting, my summary rows get lost in the sorting process. Do you have a workaround to prevent this from happening? Ideally, I would like my summary rows…
-
Resource exports
Hi I'm wanting to use SS more in how we do resource planning. One thing which is quite painful is the output from the export on the resource view. What would be easier as a complimentary tab on the excel export is a more "Pivot table usable" output, for the same range so something like Date Project Resource Allocation this…
-
Sheet Schema & Report Schema Documentation
Hi, I would like to recommend the following enancement. Please could the be a way to export as an Excel or Google sheet the Sheet Schema. This should contain all the information and properties of the sheet, As per the Properties Dialog box from the Sheet menu Plus all Field: * Column Name * Column Type * List Items * Also…
