Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multi…
Hello All, I created a mother sheet called Product Development which we populated via it's online form. I created a secondary sheet ( daughter sheet) called Costing in which the majority of the column…
I am hoping there is a formula to see what I will need to forecast to purchase for material received vs consumed. Any help would be greatly appreciated!
I am trying to use SUMIFS with multiple criteria, and I am failing horribly. I seem to be having trouble when I try to add the criterion to sum data from a specific year (from a Date field) and/or whe…
Hi there, I have set up Smartsheet so that when a Customer Order is fulfilled, the row of the Order is sent back to the Customer as an Order Confirmation. Also, we attach the Invoice for the Customer …
Hi, Wanted to check if there is a mechanism wherein smartsheet can store the information collected via different forms at different points in time in a single row ? Providing an example below for more…
Hi, I have a Inventory Sheet with list of items and also the quantity of each item. I also have products that use various items from the Inventory list, for example: Product #1 = 2 screws, 1 sign, and…
I'm looking to find a formula that will capture the last six months of data and then return the highest value within those six values. On excel, I've used, for example, MAX(OFFSET(B3,COUNTA(B3:B113)-6…
Hi, I'm trying to build an action item report that only shows approved items that do not meet certain criteria. So in the smartsheet, there is a check box for a document attached and several columns f…
Good afternoon We have a bid invite sheet that we fill out with prospective jobs (each row is a prospective job) to bid on. It has multiple columns of Data that if we decide to bid on the job would ne…