-
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…
-
Formula help
I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being input through the web forms so new rows are being created constantly, and the information needs to run through the sort filter…
-
IFERROR Formula Help
I would like to be able to count symbols in a column, even if there is an "#Invalid Data Type" error in one or more of the cells in that column. Will the =IFERROR formula help me? Here's what I'm working on: I am trying to determine whether or not a project has been completed early, on time, or late based on the date it…
-
Dropdown lists
Hi, Is it possible to have dropdowns linked to each other. If dropdown 1 = x then dropdown 2 contains = a,b,c,d?
