-
Collapse/Expand All in Grid View
It would be so incredibly valuable to be able to Expand/Collapse all parent/child rows in the grid view. We have this option in Timeline View and if this was also available in grid view, so much time would be saved. The functionality and ease of use would be greatly improved.
-
countif from 8 different sheets with data criteria
Hello, I have a head scratcher here, I have 8 different sheets that I am trying to pull counts from and only from a certain day. Example: All sheets have a date of outreach, all sheets have a outcome. I want to pull the count of all outcomes marked "Mbr Reached" from 12/02/2025 from all 8 sheets. Question: Is there a…
-
Getting Blank Rows While Inserting Data directly using Python
Hi Guys I have created a code which will push the latest ticket from ServiceNow Platform into Smartsheet using the Smartsheet API. I am trying to use the POST method to push the row to Smartsheet but due to some reasons it is not getting inserted even if in the activity log it keeps showing as row inserted. When I tried to…
-
Copy paste row data to smartsheet
Hi,We’re currently experiencing an issue when copying and pasting data into Smartsheet — the system limits us to batches of only 500 rows at a time. Is there a way to work around this limitation, or could this be considered as a potential enhancement for Smartsheet?
-
Has anyone used remote staffing (like CrewBloom) to support Smartsheet workflows?
Has anyone here used remote staffing support (like CrewBloom) to help manage Smartsheet projects more efficiently?
-
計算結果に＋／▲記号を自動付与できる表示形式を追加してほしい
現在、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() >=…
-
Change Order Management
Does anyone have best practices for collecting and managing Change Order requests for Project Plans please?