-
Global Report - Change filter permission
I have a Program Report (dynamic report) where I would like a user to be able to change the filters. They are the owner and admin of this report; however, they are only editor in the source sheet that makes up this report. They seem to be having issues changing the filters. Do they also need to be admin to the source…
-
日別タスクの集計方法について
martsheetでEVMを実現したいと考えています。 しかし、各タスクの日ごとの稼働実績の集計方法に悩んでいます。 現状は通常のWBS方式でタスクを管理しています。タスクごとに「開始日・終了日・計画工数」を持たせ、稼働したタスクごとに実績工数を日ごとに入力したいと考えています。 ■やりたいこと ・各タスクの稼働実績を集計したい・さらに日ごとの合計(全タスク合計)を出したい ■イメージ 【入力(縦持ち)】 日付 | タスク | 工数 10/1 | タスク① | 5.5 10/1 | タスク② | 6.0 10/2 | タスク① | 6.0 10/2 | タスク② | 3.0 【出力(集計結果)】 日付 | タスク① | タスク② | 合計…
-
"Save as new" with more than 100 items
Is there any way around the 100 item limit when using" save-as-new". I built a large reporting and dashboard structure with hundreds of individual reports and aggregate dashboards. The reporting structure is for a state agency that contracts with many partners, so lots of reports and dashboards for each individual partner.…
-
Reporting Dashboard
I have issue about dashboard view. Even the settings are published as 'anyone see the link content' but the content does not open in pc. The link does not work. Do you know how it is fixed?
-
Counting only CHECKED checkboxes in report summaries
I several reports I've created I need to get an accurate count of checked checkboxes within the summary section of the report, and currently, the summary is counting all checkboxes- whether they are checked or not. The image below shows that it's counting 4 checkboxes, but it should only be three since that's the total…
-
公開ダッシュボードを利用した際に埋め込み型のウィジェットを表示させたい
Smartsheetのアカウントを持っていない方を対象に、ダッシュボードの公開リンクを使用して公開します。その際レポートウィジェットが表示されず、ウィジェット内に以下の通り表記がされる限りです。 ダッシュボードの公開においては、ソース側(今回はレポート)の設定で公開をONにする必要があるのでしょうか。 あるいはダッシュボードのウィジェット設定で、閲覧者モード「最後のウィジェット編集者」or「ユーザ独自の視点」の選択が影響するのでしょうか。
-
"Rolling" cleared text - how to manage
I have a sheet that others update as and when they can as well as reporting by set dates. A checkbox is used to mark that the material is cleared for reporting and this is the criterion that pushes the information through to dashboards and paginated reports. Managed previously with a single checkbox that was cleared on a…
-
Text Wrapping on Report Group Headings
It would be very helpful to have text wrapping on the headings that appear when you 'group by' on reports. In our case, we group some reports by project name as this is most intuitive for the users of the reports. These project names can often be several words long, and it looks really untidy when half the project name…
-
Sheet Summary data use on reports and dashboards
Want Sheet Summary Data on a dashboard….but understand I cannot utilize Global Update if I use a Metric widget in an attempt to display it. Was told I can write a report that calls up that Sheet Summary data and then use the Report Widget Created the report…no problem, updated the blueprint with the report as "required"…no…
-
Edit Recurring/Scheduled Emails
Hello, We have a number of emails that go out on a recurring basis to specific individuals. I'm talking about the ones you can set up when you click "Send as Attachment" and where you can click "schedule" to set up what days/times the email goes out and to who. We are able to click "Edit Recurrence" but that only allows us…