-
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?…
-
How do you Set-Up Reoccuring Tasks?
Hello! I am new to Smartsheet and I am trying to take all of my tasks listed in Outlook to form my personal Sheet for my schedule. I have many tasks that I repeat weekly, is there a way to form these in the sheet? I do not want to have to list the tasks every week, I will if I need to but wanted to see if there was a…
-
Amount of Working Time Between Tasks
We have a desire to calculate the amount of work time between the end date of a task, and the start date of it's successor task. Before the update that included partial day durations, we were performing this with simple date arithmetic. Now, that arithmetic does not hold true, and we need to devise an updated formula to…
-
Multiple IF formula
Hi I am unable to figure this out. I need a formula that says: If any of the cells Barcode:Barcode contain the term "1 In Production", then add the text "In Production" to corresponding [In Production]1" cell.
