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 Functions511tom.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 Functions642noclue -
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 Functions332Carolyn_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 Functions251[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 Functions596raf45678
-
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 Functions548M. 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 Functions271Irishalum2002
-
Stavros_McGillicuddy 22 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 Functions223Stavros_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 Functions533tmccray
-
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 Functions10917TrevorM
-
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 Functions321Hans 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 Functions361Shawn 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 Functions401M. 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 Functions333Pilarmonia -
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 Functions141[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 Functions501bukkymoh01
-
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 Functions451cleversheet -
loreleijflanigan112461 27 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 Functions272loreleijflanigan112461
-
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 Functions131dishank.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 Functions353Sldollman
-
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 Functions435tlawrence17 -
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 Functions359Jason 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 Functions381kbrussel
-
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 Functions536FEspo
-
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 Functions131mwood
-
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 Functions541saltyblueocean
-
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 Functions553Kris 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 Functions592marwinrj
