-
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…
-
Smartsheet formulas with multiple columns
We're using Smartsheet for some change management, and I'm new to both Smartsheet and spreadsheet formulas. What I’d like to do is have a formula looks at a column that indicates the type of change (Major, Minor, Emergency, etc.) and then looks at a number of check boxes and adds an approval in a separate column. So, for…
-
Help with check boxes
Hello, I am trying to figure out the formula to get a check box to auto check when two other boxes are checked. In the image attached, I'd like to link the check Boxes in line with Person 1 and Person 2 to the check box in line with President Elect. How do I do that without linking all the other lines? Thanks
-
Formula vs Conditional Formatting
I was hoping conditional formatting could solve this but can we do IF/AND on conditional formatting? If not, what would the formula look like? If the End Date is in the Past AND % Complete is NOT 100% change End Date Font Red. Currently, I have a formula that will flag "At Risk" column if the date is in the past and %…