Formulas and Functions
Archives for September 2019
Discussion List
-
First post 09/30/19,Last post 10/01/19I want to assign a unique numeric value to each of the options in a drop down menu column, and have that numeric value display in an adjacent cell. Drop down menu options in each cell are: Needs Contributor Contributor Reviewing Rea…Formulas and Functions536jtlsf1 -
First post 09/30/19,Last post 10/25/19I'm new to Smartsheet and have a drop down menu that needs to tie to another column/field I am trying to create a if/then formula but obviously I'm doing something wrong as I keep getting an #UNPARSEABLE error. I'm trying to say "if …Formulas and Functions259MgtCon
-
Multiple IF Statements -- Status UpdatesAccepted AnswerAccepted Answer Julie_Boss85141 53 views 6 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 09/30/19,Last post 10/01/19Hello, I am trying to put together a sheet that reflects as a holistic "Status Update" depending on whether or not something has been "Approved", is "Pending", or has been "Denied". I attached a…Formulas and Functions536Julie_Boss85141
-
First post 09/30/19,Last post 10/06/19Hi, I have a job file that uses several VLOOKUP formulas to extract customer information, order and delivery date. When the task is finished I would like the information retrieved wirt the formulas to be embed in the task document so …Formulas and Functions133ydionne
-
First post 09/30/19,Last post 09/30/19Is there a way to populate a Contacts column on a sheet using VLOOKUP or INDEX/MATCH and have the actual contacts from the original sheet populate into the new sheet as opposed to just the names? A bit more detail: The original contact co…Formulas and Functions993anna_ashby
-
First post 09/28/19,Last post 10/14/19Hi I have a sheet which looks at another sheet and counts the number of instances of a string appear in that column based on a string in the current sheet and that works. I now want the sheet to look at the other sheet, carry out the COU…Formulas and Functions133Richard
-
First post 09/27/19,Last post 09/30/19Good evening: I am trying to add an OR to the formula below: =COUNTIFS(Priority:Priority, ="P1", Status:Status, ="Potential") Potential or Active Thanks for your help in advance!Formulas and Functions262AB
-
First post 09/27/19,Last post 09/29/19Hello, Perhaps this has been answered elsewhere - in which case I appreciate being redirected. I am trying to determine if it is possible to create formulae that summarizes a health indicator symbol (Red, Yellow, Green) across multiple …Formulas and Functions281stilesb
-
First post 09/27/19,Last post 12/04/19I work with a small Real Estate company and we lean heavily on Smartsheet for all of our task and workflow management. We have built a system of task lists, workflows, and meeting agendas that all work very well, but at the moment we have …Formulas and Functions2144Chann403
-
First post 09/27/19,Last post 09/30/19I'm trying to do an if statement for if a cell is blank to leave it blank and if not to perform an if/and statement. I did it in Excel but when I imported the file into Smartsheet it wasn’t working. So I’m trying to write it in Smartsheet.…Formulas and Functions145cpontiff
-
First post 09/27/19,Last post 09/27/19Good morning, First time using a Vlookup formula. All I am trying to do is cross reference employee numbers from one sheet to another. If the employee number exists in sheet A and is a match on sheet B, I want it to flag. I think I am…Formulas and Functions273Ryan M
-
Automatically add formula to new rowsAnswered QuestionFirst post 09/27/19,Last post 03/17/20I have a sheet with a formula set up to find duplicate email addresses. But, when new rows are added, the formula doesn't copy to the new row. Is there a way to make the the new row also includes the formula. Sidenote: when a new row is cr…Formulas and Functions1449Nataleigh
-
First post 09/27/19,Last post 09/28/19HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet IF(K$1…Formulas and Functions241SBash
-
First post 09/26/19,Last post 09/27/19Hi Community- I have a column that I want to say what phase a project is in based upon the criteria below 4 Possible Phases – “Strategy & Intake”, “Brief Finalization”, “Detailed Concepts”, “Production to Market” #1 “Strategy & …Formulas and Functions144Jim Schaffhausen -
First post 09/26/19,Last post 09/26/19I have a task list that includes what project the task belongs to. The project field is filled in manually (not a preexisting list). I would like to setup a dashboard to show a distinct list of projects that had been worked on, how much t…Formulas and Functions251Jacob
-
First post 09/26/19,Last post 09/30/19We are utilizing the RYGB properties for our Health column and trying to improve the tracking of each task using this criteria: * If a task has NOT started and no progress has been made, no color indicator * If a task has started and i…Formulas and Functions6411brenttopa
-
First post 09/26/19,Last post 09/26/19I have a sheet where I have a Status column. When I chose "complete" in that Status column, ideally I'd like to have another column (let's say it is named "Completion Date/Time") to auto-populate with the date/time (pre…Formulas and Functions392jmason105396
-
First post 09/26/19,Last post 09/26/19Community, I want a date to be filled in when I select a checkbox. I came up with the following formula but supplies the current date. I want the date cell to show the date that the checkbox was checked. So for example, if I selected t…Formulas and Functions622@ClayBuell -
First post 09/26/19,Last post 10/14/19We are trialling smartsheet and overall enjoying it so far however we have run into a bit of brick wall and any help would be appreciated! We have a main sheet with all our orders on it, using an older version to muck about with layout at…Formulas and Functions258Kerry Speirs
-
nkosikhona.msani89271 27 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 09/26/19,Last post 09/27/19Hi There, I am currently building a Dashboard and I want to show the number of Tickets that have been opened for a certain period, e.g. the number of tickets opened with a week. Is there a formula that I can use to achieve this.Formulas and Functions273nkosikhona.msani89271
-
First post 09/26/19,Last post 09/27/19This has been solved now :) Solution is to take the part causing circular reference into a separate row, plus adding another row with a simple IF formula. So we ended up with two more rows, but its functioning and doing what it should. S…Formulas and Functions276Oliver Lang
-
First post 09/26/19,Last post 09/26/19Hi, I have a problem with a metric widget I would like it to show me the row that is for current day. Is there a way of doing it or do I have to make a report. (Image)Formulas and Functions161Mixer
-
First post 09/25/19,Last post 09/26/19Hi All! I feel like I have been reviewing every community post about the IF(AND and IF(OR statements within a function but still can't seem to figure out what I am doing wrong. =IF(AND([Resolution Method]3 = "ClinOps F/U", …Formulas and Functions11AlexandriaJ13
-
First post 09/25/19,Last post 09/30/19Hello, Can you please help me figure out formula's for the follow scenarios? I have attached a copy of my smart sheet that i'm needing to apply the formulas to. #1) PC Action w/in 5 days (Column F): If the date in column D (Date 1st u…Formulas and Functions771tifair -
First post 09/25/19,Last post 09/30/19Hi, I am having trouble combining these 2 formulas: =NETDAYS([Date Sent To Rep]@row, TODAY() - 1) =IFERROR([Over Calc]@row, "") Right now I have 2 separate columns calculating, but would like to have just 1. Is it possible t…Formulas and Functions305Kyle Lewis
-
First post 09/25/19,Last post 09/25/19I have a need for a cell to hyperlink to different URL's based on whether or not the logged in SmartSheet user's email address (i.e., SmartSheet ID) is internal (i.e., works for our company - e.g., [email protected]) or external (i.e., on…Formulas and Functions231tgaleza -
First post 09/25/19,Last post 09/26/19I am trying to Count # of tasks if the task meets multiple criteria. For example, the task is green, it happened in the 2 quarter and it's in the metrics workstream. I get an Invalid Ref error in the formula. I am only counting tasks fr…Formulas and Functions141Y Mattos
-
First post 09/25/19,Last post 09/25/19Hi I have two columns. One is called "Hierarchy" and the other is called "Description" I'd like to have "Description" automatically filled with this text/forumula "=PARENT()" if the value in the Hi…Formulas and Functions191etenenbaum
-
First post 09/25/19,Last post 09/25/19Hi All, I've just started creating a Smartsheet form for people to easily add data however one cell should just be a formula so I'm using the 'Default Value' under field options but when the form is submitted an apostrophe is automaticall…Formulas and Functions581DominicR
-
First post 09/24/19,Last post 09/26/19Hi Community, I have a worksheet with a column (let's call it "FPD Factor") for calculating how many files can be scanned per day by a process. I would like for every new record created to have that column auto-populated with &…Formulas and Functions256khankoff
