-
管理者権限を付与できません
システム管理者のユーザーを、管理者権限でワークスペースに招待したのですが、閲覧者となりシートの編集を行うことができません。 ユーザー管理画面のトゥルーアップ画面では、「メンバー」の表記なのですが、シートを開いた際に「閲覧者」としてダウングレードされたと表示されます。 考えられる原因と解決方法について教えていただけませんでしょうか。
-
Change/CRAID Log Association to Project Plan Task
I'm using my Change Log as an example, but applicable to other sheets. I've manually copied the Project Plan Task ID, Project Plan Task Name, Role and Assigned To fields from my Project Plan into the Change Log. Within the Change Log I've simply made a few example requests. The relationship to any change request to the…
-
Create a new row when a cell is updated in a report
I have a Report that pulls from a source sheet. When the data in the Report is updated, I would like it to create a new copy of the row in the source sheet rather than updating the existing one. Currently, since the Report is directly linked to the source sheet, any changes made in the Report overwrite the cells in the…
-
formulas with percentage
I pulled in a number from another sheet, % Complete from Plan, that is a percent and want to subtract this from 100%. This is the formula I am using: But it renders #UNPARSEABLE
-
Add FORECAST Function/Formula
A Forecast function/formula would be incredibly helpful by increasing the value of the available data, and also its ability to be dynamic. My team has been looking for a solution to the lack of a Smartsheet forecast tool for years. This is the roadblock keeping us from exclusively using this program for all of our needs.
-
Is there a way to restrict unlicensed users from getting the pop up for a trial license?
We are trying to find a way to restrict this trial license pop up. The user groups within our company are setup on the admin side as un-licensed. We also have our domain list set up in SysAdmin as well. Not sure if there is any way to restrict this pop up?
-
Copy-Paste
Please add the functionality to copy and paste rows (from reports, sheets, or anywhere in Smartsheet) with their respective formatting, formulas, and validations, just like in Excel. Right now, Smartsheet only pastes the raw values, which forces us to export to Excel to preserve formats and then re-import. Having full…
-
Conditional formatting for Sheet Summary
In some cases it's very usefull to display a sheet summary in a dashboard. It's would be highly valuable to show this in your dashboard with conditional formatting to actively trigger your end-user.
-
Status Log Date Push to Dashboard
In a previous, recent question I asked about pushing a text to a dashboard. All the suggested solutions worked. The same scheme did not work for finding the latest date. Seems the code suggested only works for text.
-
Cross-sheet Copy and then INDEX/MATCH Help Needed
I am working on developing an End to End Testers sheet and a Defect Sheet. When a scenario test has resulted in a Defect Confirmed, I would like the Scenario ID, Scenario Name, and the Scenario Description to be pulled into the Defect Sheet. My initial approach is to break this information into 2 cross-sheet formulas.…