-
Merged: formula in a report view
This discussion has been merged.
-
Allow formulas to function in reports
Currently formulas do not update while in a report. If a value changes, you must refresh the report or window to see the updated formula. This creates a lot of confusion since we use reports to gather updates, which results in me being told "your smartsheet is broken" because the formula columns do not update.
-
Removing the "Comments" tab from exported Excel reports
Hello, everyone! I have an automated Report that exports as an Excel file attachment to a team leader every week. He uses this report to upload info into a different system (not project management, a totally different thing). Each report comes with the report on one worksheet tab and a second worksheet tab called…
-
Add Column to Row Report that was not in original sheet
Hi! I have created a Row Report containing information from just one sheet, with one "What?" criteria. I have the desire to add another column to this report, that does not come from the original sheet, just for notes purposes. This column would have sensitive information in it that I do not want the other owners of the…
-
Auto refresh reports
Hello! I am using a report that consolidates data from 40 other sheets for Power BI reporting. The report doesn't refresh the data unless you click the refresh button. Other than using selenium, is there a native Smartsheet feature to refresh on scheduled intervals?
-
Merged: Reports Picking up Parent and Children tasks from master schedule sheet
This discussion has been merged.
-
Form fields to include Comments
It would be really great if, in the manage forms section, form builders are able to insert a comments field that would populate as a comment on the row once the form is submitted. I have searched many product ideas and did not see this, but I did find older conversations in the community stating that it would be desirable.…
-
Allow Count Unique Values Only In Report Column Summary
In addition to being able to count and sum a column in a report, I'd like Smartsheet to be able to count UNIQUE values within a group. For example, I have a report shows me all tasks from multiple projects and groups by project manager. If I try to count the Project column to see how many projects each Project Manager has…
-
Index/Match Formula - No Match to show Blank
I've been skimming the community here to try and find the IFERROR formula to add to my formula below so that if there is no match, a blank cell populates instead of #NO MATCH. The end goal is to populate a blank row so that users can put the right details into this cell from their reports. NO MATCH doesn't allow this.…
-
How to sort grouped data by year
Hello, I am trying to create a report sheet that would group data by their project end date. How do I set up the grouping so the Parent header is by year 2023,2022... etc. When I group currently by project end date, it creates individual headers for each date. thank you for input
