-
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.
-
Count Distinct Using a Text Column with Values Separated by Commas
Hello! I have a column with a list of values separated by commas. I am looking to count the number of values separated by commas and eliminate duplicates. I have tried creating a helper column that converts the values to a multiselect, but I can't figure out the =COUNT(DISTINCT formula from there. Here is a screenshot…
-
MM/DD/YYYY Formula vs. TODAY
I am new to formulas and looking for a way to populate the "How Many Years?" column on my sheet vs. today's date. Thank you in advance!
-
SUMIFS with wildcard (*)
Hello, I am trying to use the sumifs formula for summing values in one column based on the first two letters in another column. This formula is not working =SUMIFS([Total Invoiced]:[Total Invoiced], [Google Location ID]:[Google Location ID], "CA*") I have tried exchanging the criteria column at the beginning as well, and…
-
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…
-
Trouble with an IF formula
Hello! I'm having trouble with an IF formula (combined with two COUNTIFS formulas as results) where I'm trying to count specific rows in a sheet based on certain criteria. The IF statement is to count status if the quarter is current or before, otherwise exclude status if the quarter is in the future. Both COUNTIFS…
-
How do you standardize addresses in Smartsheet?
Has anyone found a way to validate their address fields in Smartsheet? We are currently using a Smartsheet form to collect business license data and would like to integrate our data to ArcGIS to map the business locations. Currently, we are manually updating all of the citizen-submitted addresses which is a huge time suck.…
-
Categorize If Project Completed On Time
Hi - I have most of the formula working below except for when a project is not completed yet and the Actual End Date is not inputted, and Helper (Difference in Days) is not calculated. When the Helper (Difference in Days) is blank, I wanted to Helper (Completed) column to pull "in progress" Below is current formula with…
-
SUMIFS help!
Hello! I've attached a screenshot of what I'm trying to do. Basically, I want to do a SUM formula on the range int eh screenshot IF the left column is "Supplemental" and the top row is Monday-Friday. I thought the way I had set it up was right, but I'm getting INCORRECT ARGUMENT SET. Any help would be appreciated! Thank…