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 co…
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 Alloca…
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…
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 complet…
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 th…
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…
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 …
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 inp…
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…
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 ch…
