-
Renaming Column Name in Report
1) Is it possible to change the Name of Column in Report instead of Source Sheet. 2) Auto Columns name is appearing in the Report instead of Column Name (Ex. Created by , Modified By, Created Date and Modified Date). Is there any way to change System Columns name in the Report. Thanks for your support. Best regards.
-
Required advice on creating a view on Overdue tasks
Hi, Smartsheet champions. Does anybody have ideas on creating a view like below (or similar) on Overdue tasks? Perhaps creating a column in tasks sheet with formulas to calculate the Days Ago number and pulling a report will work?
-
Unable to Access Large Sheets But Data Still Accessible
I've been having an issue the last couple of weeks with two very large sheets. One is automatically updated via Data Shuttle and the other has rows pushed to it weekly. I can't open them directly but I know they are still functional because I can still move rows to them, other sheets can access the data via formulas, and I…
-
How to access all columns in a Report when creating a Dashboard Chart?
Hello! I have a report that is summarizing project costs, sorted first by the line-item code in the budget and then by Quarter of Completion afterword. I am hoping to represent this data graphically with a dashboard chart. The goal is to have a Bar Graph that shows the cost in each quarter, clustered by the budget item.…
-
What is the maximum row count for a report (I know there is up to 2,500 rows per page)
-
Build Report that Pulls Row and Summary Sheet Data
We are currently only able to build reports sourcing from EITHER row data or Sheet Summary data. The request here is to have an option to source from both.
-
Sharing reports with free users --- updated question
I had asked this question previously and thank @Shanky Paul for answering! I'm still trying to figure out if I give them access to the source sheet, will they be able to see the source sheet and if so, then why would I create a report? There is a column in the source sheet I don't want to share. Thank you!…
-
Formula to lookup a value based on start and end date
Hi All, I need your support on this case. I have a project to improve the current sales report layout and I need to extract the Vendor Support data for each item depend on the sales records, and the start and end date for this vendor support. Here is an example: Below is the table where I want to have the formula to…
-
Creating monthly reports and accessing via dashboard
We use a sheet to track our monthly WIP (work in progress). How do I create a report for each month so that, if needed, we can go back to look at previous months to see the trend? I'll post a screenshot of a sample. We did this previously in Excel, had tabs for each month and the Prior Change column would populate from the…
-
TODAY() returns yesterday or tomorrow depending on your timezone
Hi Community, We have an interesting issue here in Melbourne, Australia when we use the TODAY() function. At various times of the day, it can return yesterday's date rather than today's date (as it should). Took quite a while for this to be acknowledged, but the behaviour has been confirmed now by a couple of senior…
