-
Control Centre push an update to all provisioned worksheets
I have a large number of assets that have been provisioned through Control Center. I want to install a formula in one cell in a specific column. I thought I could update the template in the source folder of the blueprint and publish it, however, that functionality has been removed or I can't quite figure out how to do it.…
-
Does anyone have a project plan used to bring Smartsheet into your company?
Looking for a project plan that I could use to bring Smartsheet into my company. We are going to be needing SSO Control Center Building Templates for Control Center Building out connectors (mainly for Azure DevOps) Creating Reports (for projects but also for users to see open tasks by project assigned to them) anything…
-
Collecting info via forms, but cells are getting too full: What's the best solution?
Hi all, Here's a quick description of my set-up. We're collecting project progress updates via workflow automations. These forms get sent to various people and the main 'ask' is for them to fill in a free text entry called 'latest update' field. These entries then appear in the 'latest update' field on the main sheet. This…
-
Attachments to In-Cell Images
I cannot figure out how to automate the process of moving cells to images. I've read this can be done through power-automate, but frankly coding is out of my expertise. Is there a simpler way to do this? These attachments are added through form entries.
-
Too many years showing
How do I limit the number of years displayed on my Gantt chart? Right now it is defaulting to showing both this fiscal year and next. Isn't there a way to limit the display to JUST this fiscal year? Thanks.
-
Multiple Forms - Add info to existing row
Hello! We work with a registration form that feeds a master sheet, we want to add another form that will update or add a request for change for a registered contact, but we do not want to generate a new row, we want Smartsheet to match the name or ID to the initial registration and update the columns. Do we need a formula…
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
-
Assistance on Calculating Target % Complete & Understand %Complete calculation
I need assistance with understanding how the % Complete for parent tasks in Smartsheet. Specifically, I’m trying to understand how Smartsheet computes these percentages at higher hierarchy levels when using formulas. Even though the Actual%Complete and my calculate column of "Developed %" values for child tasks are…
-
Keyboard Shortcuts in TABLE View
Moving from Grid View to TABLE VIEW, we lost keyboard shortcuts such as CTRL+Down arrow which takes you to the lower-most filled cell. Same with CTRL+Shift+Down (or left, right, up, etc). Mimic the keyboard functionality that we have in Excel and in Grid View!
-
WBSシートから月ごとの累積金額を自動集計する方法について
現在、スマートシートでプロジェクトのWBSを管理しています。 シートには「開始予定日」「終了予定日」「予定工数金額」「進捗率」などの列があります。 やりたいことは、シートに入力したデータをもとにして、 月ごとに予定工数金額を積み上げて累積する 実績金額（進捗率を考慮して算出）も同じように累積する その結果をダッシュボードで「右肩上がりの推移グラフ」として可視化する というものです。 ExcelやGoogleスプレッドシートであれば、先頭からその行までを合計する形で「累積列」を関数で作れますが、スマートシートでは同じ方法が見つからず困っています。 質問 ・スマートシートの関数を使って「月ごとの累積列」を作る方法はありますか？…