Formulas and Functions
Archives for November 2019
Discussion List
-
First post 11/30/19,Last post 12/02/19See 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…Formulas and Functions531tom.dusnmore112871 -
First post 11/29/19,Last post 12/03/19I 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…Formulas and Functions1612noclue -
First post 11/27/19,Last post 11/28/19Hi, 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…Formulas and Functions822Carolyn_H -
First post 11/27/19,Last post 11/28/19I 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…Formulas and Functions231[email protected]
-
First post 11/27/19,Last post 11/27/19Hi 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, …Formulas and Functions1286raf45678
-
First post 11/27/19,Last post 12/02/19Hello. 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 …Formulas and Functions1138M. David
-
First post 11/27/19,Last post 11/27/19I'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…Formulas and Functions541Irishalum2002
-
Stavros_McGillicuddy 32 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 11/27/19,Last post 11/27/19My 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…Formulas and Functions323Stavros_McGillicuddy
-
First post 11/27/19,Last post 11/27/19I'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…Formulas and Functions893tmccray
-
First post 11/27/19,Last post 02/14/20We 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…Formulas and Functions13017TrevorM
-
First post 11/26/19,Last post 11/27/19Hello, 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.Formulas and Functions331Hans Meyer-Bertheau
-
First post 11/26/19,Last post 11/26/19I 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…Formulas and Functions771Shawn Borror
-
First post 11/26/19,Last post 11/26/19Hello. I am trying to create a graph that shows the top 10 tasks ranked by the variance between Initial Duration and Actual Duration. To make this work, I want to ignore tasks that are parent records. What would this formula look like? I h…Formulas and Functions611M. David
-
First post 11/26/19,Last post 11/26/19Hello, I have problem with the dates in the formula below (in sheet summary) =AVERAGEIF([Date of request]:[Date of request], >07.01.2019, [Completed in days]:[Completed in days]) The Smartsheet returns me the value 0 that is wrong ca…Formulas and Functions563Pilarmonia -
First post 11/26/19,Last post 11/26/19Hi I am running a number of tasks in a sheet, with each task having its own Start and Finish date. What I need to find out, is a "free" period when there is absolutely no task running. Example: Task A is from Jan 1 to 10; …Formulas and Functions151[email protected]
-
First post 11/26/19,Last post 11/26/19I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where al…Formulas and Functions561bukkymoh01
-
First post 11/26/19,Last post 11/26/19Copy/paste this to quickly build these formulas: =IFERROR(INDEX(ReferenceSheetPickContentColumn, MATCH([CurrentSheetMatchColumn]@row, ReferenceSheetPickMatchColumn, 0)), "") Then just double-click the concatenated-word segments…Formulas and Functions571cleversheet -
loreleijflanigan112461 34 views 2 comments 0 points Most recent by loreleijflanigan112461 Formulas and FunctionsFirst post 11/25/19,Last post 11/27/19balls. 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 sub…Formulas and Functions342loreleijflanigan112461
-
First post 11/25/19,Last post 11/27/19How 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.Formulas and Functions117SYSPK -
First post 11/24/19,Last post 11/25/19I want Wednesday as the weekof based on the date for e.g. If cell A has date of 25th Nov, the weekof in cell B for that date should be 20th Nov If cell A has date of 27th Nov, the weekof in cell B for that should be 27th Nov If cell A h…Formulas and Functions121dishank.jain112376
-
First post 11/24/19,Last post 11/25/19I'm trying to calculate count of dates using the formula CountIF([date]:[date],"11/25/2019") Wherever i have the date as 11/25/2019, it should give me the count, it should give me the total count. But the formula isn't giving a…Formulas and Functions222dishank.jain112376
-
First post 11/22/19,Last post 12/04/19Hi community, I'm looking for help on identifying milestone tasks that span multiple weeks (see screenshots below). Our project plans have a "weeknumber" helper that checks the END date of a milestone task to set the week num…Formulas and Functions633Sldollman
-
First post 11/22/19,Last post 11/25/19So I've been tasked with creating a timesheet for our consultant agency by quarter, so each sheet will cover three months, why it has to be in Smartsheet I'm not sure. Context Each day, employees have three types of projects they can be …Formulas and Functions565tlawrence17 -
First post 11/22/19,Last post 12/05/19=SUM(CHILDREN()) / (COUNT(CHILDREN()) + COUNTIF(CHILDREN(), "")) I am using the above formula for percent complete in my project plan as seen by my picture. My question is when certain parts of the project have not been started …Formulas and Functions589Jason Cocco
-
First post 11/22/19,Last post 11/25/19Hello! I am looking for help in building a formula for a sheet. I create semester reports on a sub-group of persons that we track in a master database. Because this database is extensive (multiple years) but my reports are created from…Formulas and Functions631kbrussel
-
First post 11/22/19,Last post 11/25/19Hi. My name is Frank. I have been working on this formula for quite a while now including requests to Smartsheet support. The formula is to raise a red flag when the end date is less than 3 days away with specific status options. I finally…Formulas and Functions826FEspo
-
First post 11/22/19,Last post 11/23/19Hi, I've been using Smartsheet for around 6 months and would class myself as intermediate. However when it comes to Formula's I'm certainly a novice! I have a Smartsheet that acts as a Hotel rooming list. Users can load their Hotel Check …Formulas and Functions161mwood
-
First post 11/21/19,Last post 11/22/19Hi, I am attempting to create a rolling average to replicate a "trend line" one might see in excel graph. Having trouble visualizing the formula I might use, but landed on AVG(COLLECT()) as a plausible option. Hoping to poll th…Formulas and Functions1171saltyblueocean
-
First post 11/21/19,Last post 11/22/19I am new to Smartsheet and using it to replace old InfoPath forms. One thing I cannot find an elegant solution for is expanding fields/sections. Basically, I want to send an instructor a form that asks which courses they would like to teac…Formulas and Functions673Kris Dysert -
First post 11/21/19,Last post 11/22/19hi all, would love some help here for this-- I have a column that contain these strings in a cell: "relates to ABC-25277, relates to AF-4329" "is caused by ABC-33334, relates to ABC-33362, relates to AF-10303" …Formulas and Functions1202marwinrj
