I have a sheet set up so that when a checkbox is checked, the price of a product generates in the column next to it. I also want to be able to capture the sum of everything in the price column, but wh…
I asked about this back in April and got a few suggestions but nothing that really worked for me so I'll try again. I keep track of the hours charged to around 35 projects by people in a dozen functio…
I have a formula such as: =NETWORKDAYS([Planned Start]1, [Actual Start]1) When the Planned Start date is say 10/29/14, and the Actual Start date is 10/30/14, the result is 2. To me, the difference bet…
Smart Sheet has proven to be an amazing tool. In using it, I have built several reports that are starting to take up too much space on my display. Some of these reports are very similar (Quarterly rep…
We use Smartsheet to manage several projects, with multiple and repeat customers. We need to create a report that reviews (2) columns (distributor and customer) from serveral sheets. We would like the…
Hi Everyone, I currently am importing a sheet to manage in SmartSheets and one of my cell formulas is not functioning. Can someone please let me know if there is a work around to this. Currently in ex…
I'm trying to get the =COUNT(Children()) formula to work with a criteria. For instance, I have children that require a status of 'In Progress' or 'Completed', when the status is 'Completed', I want th…
Hi all, I'm fairly new to Smartsheet, and have been fiddling around with it on my own, trying to build a database to keep track of product registrations (see the screenshot below). It uses three level…
I am currently trying to get a formula to work in Smartsheet that will count the requests we have outstanding that havent been completed and are over 41 days old. But that will also take into account …
Hello! I have the RYG balls working great in conjunction with a "Complete" check mark and "Due Date" ranges. However, I cannot seem to figure out how to apply the forumla to the entire column without …
