-
Question: Formula results in reports
Hi! We use formulas in sheets. When will the calculation be done? Ony when having a sheet open? Or also when using the column in a report? In other words: If the formular uses TODAY or s.th. like that, the result differs from day to day. But is the result okay, when the sheet hasn´t been opened for a few days, but used in…
-
Duplicate Columns in Report
Hello, I have four different promotional calendars that I am trying to merge into a summary. Each has month/week/day/date columns. When I create the report I want one set of those columns and then the promo/notes/$ etc from each individual sheet. Is this possible? It's very unsatisfactory to have four rows of dates with…
-
Creating a Cash Flow Model
Dear Developer I would like to know if someone would be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers…
-
Calendar View in Insights?
Can anyone tell me if there is a way to include a report that is using the calendar view in Sights? When I add my report, it only shows the Task Table view and not the Calendar view. Appreciate any thoughts or suggestions. Thx!
-
Bug: Report formatting inconsistent
I have conditional formatting in the sheet based off of this [Hrs Over SLA] column. The conditional formatting is correct in the sheet but incorrect in the reports for only some rows (see circled for example, where -67 is highlighted on some rows but not in others) How does one resolve this issue?
-
Report ignoring "is blank" parameter
Hi all, We have a report that is suddenly not functioning properly. The report pulls all projects that do not have a Start date and has been functioning without issue until this week. Two of the newest projects given dates are still showing up in the report after deleting and re-entering, refreshing the report, rebuilding…
-
Freezing Column Headings for Reports embedded in Sights
Hi there Are there any plans (or was anybody successful) on the topic of freezing column headings in reports. In particular when the report is embedded in a Sight? Thanks for your advice. Regards jan
-
Shortcut list in Sights
If I want to add a widget which shows clickable links to Word document files in Sights (shortcut list), is it possible? See the snapshot below. ( I found this snapshot at https://www.smartsheet.com/how-create-dashboard-excel)
-
Admin in a Report Workspace?
Hello - I have an unlicensed user that would like to be able to edit the report properties for a report that I created for him. I know you need admin rights to the whole workspace, but I can't do that because he's only allowed to have edit on the master sheet. If I create a new workspace only for his reports where I give…
-
Reporting Roll Up
Reporting newbie and need guidance. I have a standard sheet which has an Activity column where the drop down list is Active, Closed, Inactive, Requested, etc.) Each item in the row is tied to a dollar figure. Can Reports pull both columns, but roll up the Activity column by name into a total dollar figure? i.e. 2 rows…
