-
SUMIF
I am new to smartsheet so this may be a simple question. I want to sum up the total hours of a project based on the status of the column. I.e. total amount of hours complete, not started etc. The 2 colunms I am interested in are Status (on track, complete etc) and Duration I have tried this ...…
-
IFERROR -- Suppress Error Help Needed
Hello! I hope you're having a terrific day! I am looking for suggestions for using the IFERROR formula to suppress and error message. Here's the set-up: Columns: Planned Allocation = Out-of-Box Allocation column Planned Effort by Day = [Allocation] * 8 Duration = Out-of-Box Duration column Sum Planned Effort (Estimate) =…
-
Sheet Summary
I have a sheet that I created as a log essentially. What I'm wanting to do is create a "report" that summarizes the data. As an example, I want to report total records, smallest number, largest number, and count of records with a specific condition. How would I go about doing this?
-
Plus or Minus based on text
I am currently setting up an inventory management sheet that has a webform. I want to be able to have data updated based on one column. What I have is a column that is Shipped / Received. When completing the form, if the user chooses Shipped, the QTY column displays -10 and then takes this away from total stock on hand. If…
-
Stakeholder Management template
Hi there, I found some Stakeholder templates I'd like to use: https://www.smartsheet.com/free-stakeholder-analysis-templates When I click download the free template - it downloads an Excel file. In the file it has a button "Click here to create [template name] templates in SmartSheet". All it does is open SmartSheet. No…
-
Sum of hrs utilized per client
Hi Smarties, I created a time tracker with each column with drop down list for different clients. 1. I want to sum all the hours used per client and to appear in one cell per client, so I can link the cell to auto populate. I am familiar with step 2( cell linking). Can someone suggest how to run the report on a sheet with…
-
Date checkbox formula
Hello, I have a column of dates which are showing when an item expires. I want to have a column with a checkbox and a formula in it that will tick if the test date less 365 days is within the current month of todays date. So basically the test date less 365 days, and then checking if that date is within the current month…
-
Formula help
I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being input through the web forms so new rows are being created constantly, and the information needs to run through the sort filter…
-
Send Row - Filter Save
I utilize the Send Row feature on a daily basis. The majority of the time, the columns I select from the "Customize" section are the exact same. It would be awesome if I could create a filter and have the ability to select it as opposed to manually selecting all of the columns every time. Thanks
-
Create Gantt from End to Start
Hello! As a project manager, I often find myself needing to make timelines starting with my end date. However, I have only been able to make Gantt charts in Smarsheet (with dependencies) that I can change the very first start date and then the durations, but I can't work backwards or change start dates to meet my needs! Is…