-
Date Formula
I am trying the add numbers within certain date ranges that are from today’s date, and between 30 to 180 days in the past. For example, see below table DATE NUMBER 10 Feb, 2019 2 14 Jun, 2019 6 15 Oct, 2019 5 28 Nov, 2019 3 I want to add just the 5 and 6, and get 11 as my answer in my Summary Sheet Formulae cell. What is…
-
Assign a value to text
Hi, I'm a newbie. I have an evaluation form where responses are Average, Very Good and Superior. I'd like to have another field in the smartsheet populate upon response with a numeric value. 5 for Average, 10 for Very Good, and 20 for Superior Is it possible to do this using formulas or is there a way to assign a numeric…
-
VLOOKUP for a range of numbers
Hi Community, I am looking to try and do a VLOOKUP against a range of numbers versus a single value. The function as I know it today only allows you to look up a value and pull the corresponding value for it (i.e., If the color is Green, then put 2 or if the color is Red, then put the number 3) In my use case, I am looking…
-
Populate Start and End Dates with Today based on status
My sheet has Start Date, End Date and Status columns My formula in Start Date is =IF(Status@row = "In Progress", TODAY()) My formula in End Date is =IF(Status@row = "Complete", TODAY()) My problem is the date values disappear when the status changes. How can I make the Start and End Date values stick once the field is…
-
Counting values in a multi-select column when "Yes" in another column?
I'm trying to count instances of a specific selection in a multi-select column when "Yes" is in another column. I've tried various FIND, COUNT, COUNTIF, COUNTIFS then IF or AND, but I'm not able to figure this one out. This one ALMOST works, but it won't count when another value is selected in the multi-select:…
-
VLOOKUP to Return Formula?
How can I use a VLOOKUP to return a formula instead of a string? How should that formula appear on the source sheet? I've tried putting it in quotations then extracting with FIND, but no luck.
-
Formula for "Overdue" in Status Column
I'm having trouble with creating a formula that flags my status column as "overdue" when I'm not at 100% complete and past a tasks end date for that line. i've read a lot of the other posts but none of the formulas seem to apply or work when I input them. Please let me know your thoughts. Thank you!
-
Formula for RYGG symbol based on RYGG symbols in 6 other columns
balls. The 6 other subcategories/column names are: * Financial Status * Quality Status * Staffing Status * Delivery/Operations Status * Customer Satisfaction Status * Subcontractor Management Status The Overall Status is green if all subcategories are green. The Overall Status is yellow if 1-3 subcategories are yellow. The…
-
put current date when checkboxes are checked
Hello, I want to configure a formula to set the current date when 2 checkboxes are checked. I have configured 1 date column and 2 checkboxes columns. I don't want to use the auto-modify date column for this purpose. Please help.
-
Auto assign based on value in Field
I would like to auto assign and update the Assigned To field based on a value in another field. I've tried something like this; IF([Contract Type]=NDA, John Doe) So if Contract Type equals NDA, then put John Doe in the Assigned To field otherwise keep blank. Can someone assist?