-
Still Looking for an IF function that does nothing to the cell if False
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 functional areas on a weekly basis and send the monthly total into our finance team for their revenue recognition process. I use…
-
Confused by NETWORKDAYS results
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 between those two dates is one day, not two. I don't have any holidays set for these dates, and I've tried wrapping Actual…
-
One tab, multiple reports?
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 reports, for example, are taking up four tabs per year) and I want to consolidate them into one tab. How do I create multiple…
-
Consolidating names in a Columns
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 end report to combine the (2) columns from all of the sheets and remove any duplicate names from each column. I have gotten…
-
Calculating Years Of Service
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 excel I have it as a =datedif formula. Smart Sheet currently shows the following error in the sheet #unparseable. Thank You
-
Count Children if Criteria is Met
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 the Count to reflect the number still 'In Progress' as opposed to ALL the items listed below. is it possible?
-
Is there a way to flag a row if not indented
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 levels of heirachy: - Product level - Country level - Application level It's very large, with thousands of rows, and will be…
-
Trying to get a formula to work
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 when new lines are added to the document. The formula I have got working in excel is: =COUNTIFS(B:B,"<"&TODAY()-39,C:C,"")…
-
RYG Balls Default to Yellow if Due Date is Blank
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 seeing a bunch of default yellow balls if the row does not have a due date entered. Is there a way to hide the balls all…
-
Two Separate Date Fields into one sum
I need to give per diem to employers for days worked for two events. Some will work one, some will work both. I have a formula that works great if they are working both events, but get the #MISSING OR INVALID PARAMETERS" message when only one event is worked. Does anyone know how I can get a column to return a "0" date?…