-
Trying to use sumif with dates
I am trying to sum values from Study column which only have a value in start date column less than today's date. =SUMIF([start date]1:[start date]9, "<"&today, [Study]1:[Study]9) the result is #UNPARSEABLE and I don't know why. Does anybody have advice? ex: start date Study sum 11/1/17 12 11/1/18 3 12
-
In excel you can have multiple worksheets in one document. How does this work in smartsheet?
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…
-
Manufacturing Scanning
We manufacture an industrial machine. As the system moves through the process at each station we would like to update the status of each machine with a qr code or a barcode, and trigger automation rules ie send emails or alert for issues if they come up. We want in the future to populate the smartsheet with info from…
-
Help on Formula: if function
Hi all, Please need your help. I'm new to formulas and I've been trying to figure out the right formula for my project status and progress report but I kept getting errors. I have tried the below formula in excel and it worked but not in smartsheet (the smartsheet formula below is another trial I did that did not work).…
-
Sum if there is any text in a range
I'd like to make a sum total at the bottom of a sheet in which I add only amounts if the cell in the same row has any text. I tried using this formula: =SUMIF(Location221:Location90, >0.01, [List Price]221:[List Price]90) , but it only works if there are numbers. Any help would be appreciated!
-
Compare two dates and apply conditional formatting
I have two columns of forecasted dates UTILITY and IN SERVICE. When the UTILITY date is past the IN SERVICE date I want both cells hilighted. For example if UTILITY = 9/30/17 and IN SERVICE = 5/10/17, I want both cells to be red. I understand That I'll have to use a third column to base the formatting from but I cannot get…
-
How to total quantity based on similar name in column
I am trying to total points based on the persons name. Basically one column has the names, some of them duplicates. Another Column has points. I need a third column for total points at the end that looks at the names, finds those that are the same and totals the points for that person in the total points column. I have…
-
Mark child if Parent meets criteria
Hi- I see lots of threads to mark a parent if a child meets a certain criteria, but I am looking for the opposite. I have Material, Labor, and Subcontractor Parent rows and would like to mark the children with either a number or letter indicating if it is a child of one of those parents (Material =1, Labor =2,…
-
Sum of Parents
I keep track of pending transactions in a real estate office, and have each month as a parent and the closings scheduled as children under the correct month. On the parent row of each month I've got totals showing for the children. This all works great. What I can't figure out is how to total the parents. At the bottom of…
-
Stop Counting NETWORKDAY after Done Box is checked
Hi everyone, I'm hoping this is easy to read, it is hard to explain. I am trying to STOP counting days from commencement date of a project once the DONE box is checked. I have managed to make it work without using NETWORKDAY, using this formula =IF(Done1 = 1, [Last Updated]1 - [Commencement Date]1, TODAY() - [Commencement…
