-
日別タスクの集計方法について
martsheetでEVMを実現したいと考えています。 しかし、各タスクの日ごとの稼働実績の集計方法に悩んでいます。 現状は通常のWBS方式でタスクを管理しています。タスクごとに「開始日・終了日・計画工数」を持たせ、稼働したタスクごとに実績工数を日ごとに入力したいと考えています。 ■やりたいこと ・各タスクの稼働実績を集計したい・さらに日ごとの合計（全タスク合計）を出したい ■イメージ 【入力（縦持ち）】 日付 | タスク | 工数 10/1 | タスク① | 5.5 10/1 | タスク② | 6.0 10/2 | タスク① | 6.0 10/2 | タスク② | 3.0 【出力（集計結果）】 日付 | タスク① | タスク② | 合計…
-
Add Custom, Pre-Set List of Update Request Dates
Smartsheet does not allow users to enter a list of unique dates for an Update Request to be sent out. The closest users can get to this feature is setting the Update Request to be sent on a certain day and time, however, this allows the user to enter only one date for one request (or a repeated sequence like daily, weekly,…
-
Getting an error "Web.Contents failed to get contents from 'https://api.smartsheet.com/2.0/home'
I have a PowerBI dashboard which I have connected to Smartsheet report which was functionining normally over the past year. I downloaded the latest version of the Power BI on 06-Oct-2025 [ Version: 2.147.1085.0 64-bit (September 2025) ]. I am getting the following error "Web.Contents failed to get contents from…
-
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…
-
"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.…
-
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…
-
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…