-
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
-
Need Formula for Subtracting Order Quantities from Inventory Quantities
Hi! What formula would I use in Smartsheet to automatically subtract a quantity from one sheet based on what is submitted in another sheet? I have one sheet that is where we will manage the "orders submitted" and on that sheet is different columns for different items that can be ordered and the quantities requested for…
-
New to SmartSheet - 2 questions on functionality
1: When using a SS form, is there a way to deny a duplicate entry based on an employee name or number? 2. Is there a way to somehow link from SS to Outlook to create calendar invites based on a date field in the SS? Thank you! Kat Gavigan
-
Automations to move rows to another sheet is moving more than requested
Hello Smartsheet Community, I have created an automation to move rows over to another sheet when a certain phase and date are triggered. This automation is currently moving over those rows, but other rows in addition to the ones it is requesting. These other rows shouldn't be moved at all as the phase is not listed as one…
-
Issue with automation process reporting a date in a special column
In the Smartsheet sheet “CRS RO Master” we have programmed an automation called “Track Changes in dates, confirmation and LHG code” [PICTURE 1] This one should report a date of a change in the columns “CRS GO LIVE DATE” and “PMS Go LIVE DATE” in the column “. CRS Check date changed”. [PICTURE 2] The update of the “Go live…