-
Sheets with Formulas & Web Forms
Whats the best way to handle a sheet (with formulas) populated by a web form? Right now, each Web Form populates at the end of the sheet, where the formulas stop, how can I eliminate that from happening?
-
Calculate duration excluding Weekends
Afternoon, I have a smartsheet where I have a start/received date and a sold/end date. I calculate the difference to determine the duration however I need to exclude Sat & Sun (Friday if possible) in the formula and thoughts? =NETDAYS([Date Received from xxx]263, [xxx Date Shipped Out]263)
-
Summing Values
Currently I have a Spreadsheet that catalogs potential software enhancements. In order for us to determine prioritization we use a spreadsheet to calculate results based on a rating of 1-5 based on 6 criteria. We also assign each criteria a weight as some of the criteria is more important than others. I'm trying to create…
-
Card View Lanes / Drop down
I'm using a sheet populated by a web form and using Card View as "Default" View. Card View is Viewed By "Machine Submitted By" The "Machine Submitted By" is a drop down selection on the Web form Is it possible to have "COMPLETED" as a lane on Card View WITHOUT allowing it to be a selection on the web form dropdown?
-
Helpful Things I've Discovered About Smartsheet (Long)
I've been using Smartsheet for about 2.5 years now and gradually discovered how great it is for many tasks within a our small consulting company. While I originally started using Smartsheet for its project scheduling capabilities on large projects, I've ended up using it for much more. During that time I've discovered many…
-
Copy of standard % Completed column
I'm looking for the option to have 2 columns with % Completed, to compare actual with the baseline. one standard functionality with Actual value, second that I want to create to use as a baseline value Is there a way to copy/create the same column as % Completed ?
-
Reference a value from 1 sheet in a formula
Is there a way to reference a specific value from one sheet into a formula on a different sheet. For example Sheet 1 Row 1 Column 1 has a value of 5 Sheet 2 would like to reference Sheet 1, row 1, column 1 in a simple SUM formula =SUM(Sheet1:Row1Column1+Sheet2:Row5Column3) If Sheet 1 Row 1 Column 1 has a value of 5 and…
-
RAG Formulas
I have a project sheet and I have used formulas to create metrics. I have a RAG column and want to simply create four metrics: I am struggling to find the correct formula to simply count the following: * RAG Status Green * RAG Status Blue * RAG Status Amber * RAG Status Red Many Thanks
-
Is there a way to use LOOKUP to get a total qty for the reference if it's been entred multiple times
Hi, I'm really not sure if I'm going about this the right way, but I'm trying to create a 'Bill of Materials' within Smartsheet for a construction project. As per the two pics attached, I would like to get the value of a product that is mentioned multiple times in a particular column. For example, 4 of PRODUCT 2 is going…
-
OR formula help
I tried to modify the OR formula and combine it with a function involving RYG symbols: =IF(OR(IF(TODAY() - [Order Due Date]2 > 0, "Red"), IF(ISBLANK([Order Date]2, "Red")), IF(TODAY() - [Order Due Date]2 > -4, "Yellow", "Green"))) There are basically 3 columns: Order Date, Order Due Date, and status (RYG). I am trying to…
