-
How do I correct this column formula?
=IF(AND((ISBLANK([Item 2 Mob Mark-up 8%])),(ISBLANK([ Item 3 Mob Min P-621 Runway]))),11000,"") I am asking it to look at two @row cells to see if they are blank, if so enter 11000, if not leave it blank. It seems so simple but every time I get an error.
-
Health Status -multiple criteria and blanks
Hi, I have searched the forum and tried multiple formulas, but I'm not having any luck. Can you please help me? I have a "Due Date" column and "Status" column, and need the Health Column (red, blue, yellow, green) to show this: Green = Completed Blue = Not Started (and due date greater than 14 days away) Blue = Due Date…
-
How do I best link a list of entries in one column to an entry in another column?
What I'm looking for is the ability to create a list column called "Product" and have another column called "Options" which would have another list of entries filtered based on the selection in the "Product" column. Any help would be greatly appreciated.
-
Sum of Children not working
I have 1 Sum of Children formula not working and can't figure out why it isn't working. Here are some screenshots. What am I missing. It keeps giving me $0 where the formula is and should be giving 182.16
-
Cross Sheet Reference COUNTIFS
Hi there, I'm fairly new to Smartsheets so I apologize if there's an obvious answer to this question, but here's my situation. I have a sheet that tracks projects and their status. Along with the status column, there's another column that auto-populates the date a project is marked as "Completed". I want to create a metric…
-
NETWORKDAYS to Calculate Duration
I need to calculate the duration between two dates. One of which happens to be in the future, however I didn't think that should matter. The screenshot below shows my data, and as you can see I am getting the #Invalid Data Type error, why I don't know why. My Duration column is set to text/number. And the second screenshot…
-
Formula column for Parent Rows only
Hello, I want to use a formula column for parent rows that calculates the % remaining of POs we're tracking. I want the cells in the column for children to be blank and not display a result for % remaining. Is this possible? If so, can you assist me with the formula? I am using this formula for the parent rows:…
-
AVG a column, Collect the data for a specific employee, yet needing to exclude zero
Here is my formula: =AVG(COLLECT({Bio Validation Completion Time}, {Bio Validation Schedule Scientist}, [Principle Investigatorss]@row)) Which is working; however, i want to exclude zero's. I tried this: =AVG(COLLECT({Bio Validation Completion Time}, {Bio Validation Schedule Scientist}, [Principle Investigatorss]@row,…
-
Auto-Number conditioned
Hello, I need to create an auto-number field with these characteristics: Prefix: 2 digit from the alphabet (start with AA). Fill: only 3 digit from 001 to 999. When I'll reach 1000, how I can increase the second letter of the alphabet of the prefix and restart to 001 (example AB001)? At same time when I'll reach Z, how I…
-
Why does 'range' number update?
My formula previously was; =COUNTIF({Range 1}, CONTAINS("Name", @cell)) which worked perfectly. All of a sudden this stopped working. When I update to; =COUNTIF({Range 4}, CONTAINS("Name", @cell)) it works again. Why would the range number have changed and how do I fix it?