-
Sumifs formula shows wrong value
Hi., I have two sheets: one is the Master Sheet, where multiple people enter and update their status, and the other is a Report Sheet, which summarizes the data using a SUMIFS formula. I’ve been using this setup and formula for about two years without any issues. However, for the past two days, the summary sheet has been…
-
Access to Smartsheet report not working as expected
Hi, I have a report which is generated out of 6 different sheets. To all the other 6 Sheets, I have given a person "View access" and to the report created out of 6 Sheet, I have given "Editor - Cannot share" access. Still the person is not able to see the report. Then I have given "Admin" access as well, but still that…
-
日別タスクの集計方法について
martsheetでEVMを実現したいと考えています。 しかし、各タスクの日ごとの稼働実績の集計方法に悩んでいます。 現状は通常のWBS方式でタスクを管理しています。タスクごとに「開始日・終了日・計画工数」を持たせ、稼働したタスクごとに実績工数を日ごとに入力したいと考えています。 ■やりたいこと ・各タスクの稼働実績を集計したい・さらに日ごとの合計（全タスク合計）を出したい ■イメージ 【入力（縦持ち）】 日付 | タスク | 工数 10/1 | タスク① | 5.5 10/1 | タスク② | 6.0 10/2 | タスク① | 6.0 10/2 | タスク② | 3.0 【出力（集計結果）】 日付 | タスク① | タスク② | 合計…
-
Deactivated Account Reactivated - Access old documents
I recently reactivated my smartsheets account and was hoping there was a way to gain access to the documents I have before my account was deactivated previously
-
Trying to create a new sheet in a Workspace is throwing an unexpected exception C# SDK
I am trying to create a new Sheet in a specific Workspace using the Smartsheet SDK for C# and I keep getting an unexpected exception The statement above compiles just fine. The Workspace ID (wkspID in the code) is correct. I can create the Sheet just fine locally but the sheet does not have an ID until it is created in…
-
Force refresh of page if User uses back button on Browser
I would like to find out how I can force a page refresh if a user press the back arro / button on their browser
-
Solution to manage accidental deletion
Good afternoon, Recently we have started one of our sheets in Card View and on a handful of occasions, we have had users deleting cards (or rows) from the sheet, simply by clicking the delete button on the keyboard by accident. I have done a manual test on a copy of the sheet and doing so does not prompt the user to ensure…
-
Refresh Button on the Sheet
It would be great to be able to refresh the sheet as it is possible in the reports.
-
Editing rows using forms or some other android UI
I'm a freelancer, and I want to use smartsheet to schedule jobs and do basic accounting. I have a 'new job' form to create a row with customer and job info. I need a way to then add more data to that same row later, once the job is completed (total price, material cost, etc). Is there a way to do this with a…
-
Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…