-
Users Submitting From Excel to Existing Sheet
Goal: I'm looking for a way for employees to copy/paste or upload new rows of data from Excel into Smartsheet without seeing the full sheet and ideally without needing a Smartsheet account. Project Overview: I'm building an expense report system where employees submit weekly expenses for review and approval. Currently,…
-
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…
-
formulas with percentage
I pulled in a number from another sheet, % Complete from Plan, that is a percent and want to subtract this from 100%. This is the formula I am using: But it renders #UNPARSEABLE
-
Add FORECAST Function/Formula
A Forecast function/formula would be incredibly helpful by increasing the value of the available data, and also its ability to be dynamic. My team has been looking for a solution to the lack of a Smartsheet forecast tool for years. This is the roadblock keeping us from exclusively using this program for all of our needs.
-
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
-
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…
-
Status Log Date Push to Dashboard
In a previous, recent question I asked about pushing a text to a dashboard. All the suggested solutions worked. The same scheme did not work for finding the latest date. Seems the code suggested only works for text.
-
Cross-sheet Copy and then INDEX/MATCH Help Needed
I am working on developing an End to End Testers sheet and a Defect Sheet. When a scenario test has resulted in a Defect Confirmed, I would like the Scenario ID, Scenario Name, and the Scenario Description to be pulled into the Defect Sheet. My initial approach is to break this information into 2 cross-sheet formulas.…