-
Sum by Month in Report
I have a report created from 19 sheets - these sheets have delivery dates and project values. I want to sum by Month. See screen shot of what I have so far. I can't get it to sum, September, October, November and December independently. HELP
-
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.
-
Is there a better way to get the results I am looking for?
Good afternoon, all! I have been tasked with creating an in-depth catalogue of SKUs for my company. Currently, I have a set up that works but is going to be very manual with change management. I have one sheet that is my data dump. It has all of the information located in one spot. I am then going to need to pull this…
-
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.…
-
Help me brainstorm with my staffing calculation Issue.
Hi all, So, help me out here i'll state the facts and the current case here. I need a staffing calculation every hour per zone. Data is received every 15 minutes through a shuttle. Below you can see the current process. Don't mind the red square and mark. Data is being updated in box and moved to smartsheet with a data…
-
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スプレッドシートであれば、先頭からその行までを合計する形で「累積列」を関数で作れますが、スマートシートでは同じ方法が見つからず困っています。 質問 ・スマートシートの関数を使って「月ごとの累積列」を作る方法はありますか？…
-
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…
-
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…
-
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…