-
Phantom Smartsheet link
In RM I thought I might be able to connect to one of my project plans, so I followed the link to connect to Smartsheet, but I didn't have the right access so I returned to RM. But now I have a link to Smartsheet that is blocking my resource from being able to enter time in the project. I've looked in the project setting to…
-
Add "Links" to row action indicator column
With so many organizations using Sharepoint, Teams, etc. now, it would helpful to have a dedicated spot to include Links to documents/files just as Smartsheet has made available the Attachments window to attach documents to sheets (even if it is to just document the link existence versus a "click to go to" feature).
-
計算結果に＋／▲記号を自動付与できる表示形式を追加してほしい
現在、Smartsheetでは数値の表示形式として「通貨」「カンマ区切り」などが選択できますが、計算結果に対して以下のような表示をしたいニーズがあります。 要望: プラス値の場合は「＋」を、マイナス値の場合は「▲」を数値の先頭に自動付与できるようにしてほしい。 さらに、マイナス値は赤字で表示できるとより分かりやすい。（※文字色は条件付き書式で対応可能ですが、記号付与は現状できません） 例: +1,000,000 ▲500,000 背景: 予算や収支管理で、プラス・マイナスを視覚的に強調することは非常に重要です。現状では記号を手入力する必要があり、計算結果に自動反映できないため、業務効率が低下しています。
-
数値の表示形式に『億単位』などの日本向けフォーマットを追加してほしい
現在、Smartsheetでは数値の表示形式として「通貨」「小数点」「カンマ区切り」などが選択できますが、日本の業務では金額を「億単位」で表示するケースが多くあります。 要望: 数値の表示形式に「億単位」「万単位」など、日本向けのフォーマットを追加してほしい。 例： 100,000,000 → 1億 1,234,567,890 → 12億3456万7890円 計算はそのまま保持し、表示のみ変換できるオプションが理想です。 背景: 日本の企業では、予算や売上を「億円単位」で管理することが一般的であり、現状のSmartsheetでは見やすい表示が難しいため、業務効率に影響しています。
-
Dropdown Link is not working for me.
I am testing on this dropdown link but it is not working for me. 😣 I created both the source and destination sheet. Source sheet: text number or dropdown list column Destination sheet: dropdown list column After linking the dropdown list from destination sheet to the source sheet, the data is not showing in my destination…
-
How to calculate % Planned in Father Rows?
Hi Community I created a new column to calculate the planned percentage in my project; however, in the father rows is not calculating correctly, even if I tied the percentage between complete and Planned, the percentage is not the same. I am using the following formula =IFERROR(IF(Finalizar@row = Inicio@row , IF(TODAY() >=…
-
Folder-level permissions
When will Folder-level permissions be coming out without the use of Collections? This was something discussed at ENGAGE 2023 if I recall correctly.
-
I occasionally get #ERROR results from formulas that are only fixed by a page refresh
Occasionally I have been getting #ERROR or other error messages as a formula result in cells that previously return a valid result, and nothing related to that cell or the cells that are referenced changed. The only thing that finally fixes this is to do a hard page refresh. The attached images show this, and the only…
-
Restrict Who Can Delete Sheets or create Verification Check before deletion
I recently had an unlicensed user with Admin permissions delete several sheets that I own. I was able to recover them since they fell into my deleted folder. Can this be restricted to only the owner can delete a sheet (I thought this is how it used to work?) Or can there be a notification set up to the sheet owner if…
-
Does anyone use a Change Management Form in project work and have a dashboard?
Hello. Our PMO is beginning to use smartsheet as our primary tool. We're starting with basics and have created a project plan template that also rolls up into a dashboard. We would also like to track change requests and have an overview for reasons, # of requests, # of date changes made due to requests, etc. Do any of you…