Formulas and Functions
Archives for November 2019
Discussion List
-
Date Formula ProblemIn Formulas and FunctionsSee attached. I am having problems with the date date formula. I add 12 months to the moths and the year does not change. The formula is set up to add # of months(MONTHS) to the start date (SDATE) to calculate and populate the…
-
Help with formulas using contact listIn Formulas and FunctionsI am trying to create an "Assigned To" sheet for each employee. I would like to pull from a contact list column on another page. I want it to return "Alex" if Alex is listed in the column and reference "Job"@r…
-
Assign a value to textIn Formulas and FunctionsHi, 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 Su…
-
Date FormulaIn Formulas and FunctionsI 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…
-
VLOOKUP for a range of numbersIn Formulas and FunctionsHi 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, …
-
Count Number of Records in current yearIn Formulas and FunctionsHello. I am trying to use a COUNTIFS formula to count the number of records in a second sheet that meet two criteria; the Project Status of the record matches the project status of the row where the formula is, and the year of the Move-In …
-
Formula for "Overdue" in Status ColumnIn Formulas and FunctionsI'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…
-
Populate Start and End Dates with Today based on statusIn Formulas and FunctionsMy sheet has Start Date, End Date and Status columns My formula in Start Date is =IF([email protected] = "In Progress", TODAY()) My formula in End Date is =IF([email protected] = "Complete", TODAY()) My problem is the date va…
-
Counting values in a multi-select column when "Yes" in another column?In Formulas and FunctionsI'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. Thi…
-
Forms that need to incorporate multiple line entriesIn Formulas and FunctionsWe currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is fi…