-
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.…
-
Merged: Update functions list to include regular expressions
This discussion has been merged.
-
Auto Check a box after 24 hours
I have tried to get smartsheet to auto check a box 24 hours after a row is created and column "Task Started" is not checked. =IF(AND([Task Started]@row <> 1, TODAY() - Created@row >= 1), 1) This returns #UNPARSEABLE. Any help would be appreciated.
-
Copy Parent Issue Key (link) into Child Row as a link
Hello! I am trying to pull the issue key link from my parent row into the child row. I have used the formula =PARENT([Issue Key]@row ) But it returns the text only, not a clickable link. Any ideas?
-
How to include start/end times (hh:mm) in addition to dates?
I’m building a detailed cutover/go-live schedule and need both date and time (hours:minutes) for each task’s start and end. The standard Date column type only records dates, which isn’t sufficient. I’ve read in a few places that Smartsheet has rolled out a Date/Time column type, but it doesn’t seem to be available in my…
-
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…
-
Auto sequential numbering even after moving rows
Hi everyone, I am looking to have a auto sequential number column that keeps sequential numbers even after moving the rows. For example before moving the rows: After moving the first row to the bottom, I would like to have the numbers to still be sequentially ordered in the Auto Number column: I have looked at solutions…
-
New to formulas: auto creation of + or - 4 week visit windows
Hi, I am new to formulas. If I have the initial visit date in one column, I'm wondering if there is a way to have actual dates inserted in preceding columns based on the initial visit date: 1 column showing the next possible visit date +X week or days date max and then in another column the -X week or days date min. Is…
-
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…
-
WBSシートから月ごとの累積金額を自動集計する方法について
現在、スマートシートでプロジェクトのWBSを管理しています。 シートには「開始予定日」「終了予定日」「予定工数金額」「進捗率」などの列があります。 やりたいことは、シートに入力したデータをもとにして、 月ごとに予定工数金額を積み上げて累積する 実績金額（進捗率を考慮して算出）も同じように累積する その結果をダッシュボードで「右肩上がりの推移グラフ」として可視化する というものです。 ExcelやGoogleスプレッドシートであれば、先頭からその行までを合計する形で「累積列」を関数で作れますが、スマートシートでは同じ方法が見つからず困っています。 質問 ・スマートシートの関数を使って「月ごとの累積列」を作る方法はありますか？…