-
Count Number of Children Cells that are not blank.
I'm having difficulty with this one. I have a parent row of "Rental Lead" I would like to count the number of child cells in column "Training Course" under the parent "Rental Lead"
-
IF Statement Help
Hello, I am new to Smart Sheets and apologise in advance if this is a simple question... Scenario: I have a sheet that is updated via a Web Form and i would like to have a Job Status updated depending on a few conditions: IF the Operator is equal to Unassigned then the Job Status is Unassigned IF the Operator is not equal…
-
Cell Linking Autofill or other means when sheet too big
I sent in a comment to Customer Success that the sheet is getting slow performance. The response was bust it up into multiple sheets. Well I like the idea, I'm not sure I like the solution - it make everything now manual unless someone can tell me a better way. The first four columns in my Master Sheet would need to be on…
-
IF / THEN FORMULA HELP - Multiple Numerals
How do I create a if / then formula to show one response for multiple numeral answers such as IF Column1 is 1, 2 OR 3 then Column 2 is "acceptable" 4, 5, OR 7 then "tolerable" 6, 8, OR 9 then "undesirable" 10, 11 OR 12 then "intolerable
-
Counting Total Number Correct of RYG Balls per person
Hi Can anyone help me with my a formula that will allow you to count the "Green RYG balls" which means completed for our purposes. I am trying to count the number of completed "Green" RYG balls, per person in order to use on the dashboard I am creating. I trying to display how many tasks has "John Doe" completed and I only…
-
SUMIF
I am new to smartsheet so this may be a simple question. I want to sum up the total hours of a project based on the status of the column. I.e. total amount of hours complete, not started etc. The 2 colunms I am interested in are Status (on track, complete etc) and Duration I have tried this ...…
-
IFERROR -- Suppress Error Help Needed
Hello! I hope you're having a terrific day! I am looking for suggestions for using the IFERROR formula to suppress and error message. Here's the set-up: Columns: Planned Allocation = Out-of-Box Allocation column Planned Effort by Day = [Allocation] * 8 Duration = Out-of-Box Duration column Sum Planned Effort (Estimate) =…
-
advancing dates (roll over)
I have a number of simple tasks that re-occur regularly. Is there an easy way to roll due dates over monthly, quarterly, or yearly?
-
Plus or Minus based on text
I am currently setting up an inventory management sheet that has a webform. I want to be able to have data updated based on one column. What I have is a column that is Shipped / Received. When completing the form, if the user chooses Shipped, the QTY column displays -10 and then takes this away from total stock on hand. If…
-
Date checkbox formula
Hello, I have a column of dates which are showing when an item expires. I want to have a column with a checkbox and a formula in it that will tick if the test date less 365 days is within the current month of todays date. So basically the test date less 365 days, and then checking if that date is within the current month…
