-
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スプレッドシートであれば、先頭からその行までを合計する形で「累積列」を関数で作れますが、スマートシートでは同じ方法が見つからず困っています。 質問 ・スマートシートの関数を使って「月ごとの累積列」を作る方法はありますか？…
-
Metric Sheet - Not updating with Automation Date
Hello everyone, For the past year or two, I've been using automation "Record Date" set to daily as a trigger for the cross sheet references on this metric sheet to update. As of recently, it stopped updating the references despite the automation running and updating the date. Was there a change that broke this? Thank you.
-
Sheet Not Showing in Automation Search
I've been given Admin access to a work app that the owner would like to have linked via a copy row automation to my workspace, but when I try to search for the sheet, nothing is coming up. I've tried refreshing, waiting a few minutes to see if it hadn't indexed yet, all without luck. Any ideas?
-
Is anyone available to assist me with why I cannot access my Smartsheets
I keep getting an error that I cannot access Smartsheets