Formulas and Functions
Archives for November 2018
Discussion List
-
First post 11/30/18,Last post 01/15/19I have a problem. When Smartsheet sends the form on request to an area. I need to know if after receiving a project from a form, to be able to assign a resource and the date of assignment I can only do it from an update? or there are othe…Formulas and Functions134Msantos10 -
First post 11/30/18,Last post 11/30/18Hi there, Is there a way I can use the JOIN function to merge the contents of an entire row from another sheet, but exclude rows that are blank? The contents of the other sheet is generated from a form (and being constantly updated), …Formulas and Functions1417BarneeL -
First post 11/29/18,Last post 07/22/19Does anyone know of a way to find and replace formulas in my sheet? Or to find and replace a portion of a formula that exists throughout my sheet?Formulas and Functions593Mike Wilday -
First post 11/29/18,Last post 11/29/18When I check Declined Date, it is not changing to "Declined". Can someone help? =IF(AND(NOT(ISBLANK([Submit to Design Agency]8)), ISBLANK([Submit for Approval]8), ISBLANK([Approval Date]8), [Declined Date]8 = 0), "Submitted…Formulas and Functions36Michelle Kallam
-
First post 11/29/18,Last post 12/31/18I am working on a master SmartSheet to roll up other Sheets into one. When changes are made in the linked SmartSheets, this is not reflected in the master. If I add additional rows, my master is not updated What I am missing?Formulas and Functions136Nadine_bn
-
First post 11/29/18,Last post 11/30/18I'm working on a gantt chart that is tracking teams progress on a project using agile development. Business Case / Background: When the teams provide updates to when a task is going to be completed, they reference the name of the sprint…Formulas and Functions26erin.pittman70676
-
First post 11/29/18,Last post 11/29/18Is it possible when more than one row having same value( duplicate row is submitted) an alert message goes to the user that row already exist something like this..?Formulas and Functions11Jimmy
-
First post 11/28/18,Last post 11/29/18I have a sheet that is referencing another sheet to provide counts on instances of certain values in different columns. What I'm stuck on is counting how many times a single word is used if other text is in the same cell. For example if…Formulas and Functions1293mjensen
-
First post 11/28/18,Last post 01/03/19Hello, Looking for a little quick assistance. Not sure why I can figure this out, but I guess I'm just not as intuitive with the SmartSheet logic. I have a metrics sheet that I am using to provide data from other sheets to populate a das…Formulas and Functions23DLABS Consulting
-
First post 11/28/18,Last post 11/30/18I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has been checked and to specify a region…Formulas and Functions1611KO_in_Colo
-
First post 11/28/18,Last post 11/28/18From a logical perspective, I'm trying to write a formula that says the following - If the (Issue Type = 'BUG') AND the( Status = 1 of 5 possible values), then the cell value should be a red ball, otherwise, the cell value should be gree…Formulas and Functions13tgaleza -
First post 11/28/18,Last post 11/28/18I have users completing a form to update a source sheet I use for a Dashboard. Once the sourcesheet is updated I would like to show the latest update in realtime with having to update the dashboard manually. Is this possible? If so what wo…Formulas and Functions22vlambert
-
First post 11/28/18,Last post 11/29/18Hi I've watched a few videos on RYG automation based on due dates but is anyone able to help with the IF function using categories from a drop down list instead? I.e. Looking at Recruitment Status: If someone chooses 'On Hold' from the …Formulas and Functions13dcabras
-
First post 11/28/18,Last post 01/02/19We're putting together a Proof of Concept for our project management team. We're "this close" to being able to replicate all the functionality they need. But, we're stumbling on one item. They would like Smartsheet to automatica…Formulas and Functions606mrsmorden
-
First post 11/28/18,Last post 11/28/18Hi Everyone, New to smartsheet and need some help. I'm trying to calculate a date in the future, only when the manager approval column is Approved. I've figured out the date formula, thanks to another discussion, but I'm unsure how to in…Formulas and Functions43Kelly_C -
First post 11/28/18,Last post 11/28/18Hi, I am currently facing a situation were one entity has multiple ID and country.Hence formula for region should be based on first Entity and then on Country..i think If AND formula has help like we do in excel. Can someone help me w…Formulas and Functions31Jimmy
-
First post 11/27/18,Last post 02/04/20I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy. Situation: I would like to have a form where someone selects one op…Formulas and Functions123417Dajah
-
Swathi.Chaturvedi 13 views 5 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 11/27/18,Last post 11/28/18Hi! I am trying to reference another sheet in a SUMIF. But I get "#UNPARSEABLE" I want to sum contribution $ in Column 2 if the vendor name is 9X. This info is in Sheet2. I am referencing it in Sheet1 Here is the formula : =SU…Formulas and Functions135Swathi.Chaturvedi
-
First post 11/27/18,Last post 11/28/18I am new to creating dashboards in SS. I have gone through the SS online tutorials and not finding the details I need. I need to create reports using formulas and what I have tried I have not been successful. Does anyone have suggestions…Formulas and Functions213lkemery
-
First post 11/27/18,Last post 11/27/18Hi , How to use Index and Match function in SS.Please advise with an exampleFormulas and Functions7591Jimmy
-
First post 11/27/18,Last post 03/12/19I am looking for the parent row to reflect a rollup of child row status color (RYG) AND if ALL child rows are blue (complete), have the parent row blue. I'm almost there, however, in the screenshot example below, the parent task is yellow …Formulas and Functions765mailene.h
-
First post 11/27/18,Last post 11/27/18Hi All, I have two columns where one column will have a DATE and the other one will be blank. It will never happen that both columns will have a date in them. Now I want Smartsheet to check which two cells has a Date and show WEEKNUMBER…Formulas and Functions153Krzysztof
-
First post 11/27/18,Last post 03/09/19Is there a way to save a date that something occurs? We have rows that get changed constantly, and the status balls change from Green to Red to Yellow to Gray. Any way we can capture the date that a row's status ball changes to Red, even i…Formulas and Functions276SYSPK -
First post 11/26/18,Last post 11/27/18Hi, this formula returns a blank - what is wrong? =IF(OR(MONTH([Created Date]9) = 8, MONTH([Created Date]9) = 9, MONTH([Created Date]9) = 10), "Q1FY " + YEAR([Created Date]9), IF(OR(MONTH([Created Date]9) = 11, MONTH([Created Da…Formulas and Functions3614Lisa Bruce
-
First post 11/26/18,Last post 11/26/18I am trying to sum accounts receivable for individual salesmen. I have gotten to the point where I can add if the check box under [Check Received] is marked but I do not know how to sum if a check box is unmarked. So far my formula is retu…Formulas and Functions31landon31
-
First post 11/26/18,Last post 11/27/18Does anyone have a formula that will evaluate all the cells in a row, then return the column name for the cell that has a particular value? Here's what I am trying to do. I have a Smartsheet with 23 columns, of which 5 are due dates. A 6t…Formulas and Functions1071VanessaK_SRR
-
First post 11/26/18,Last post 11/26/18I'm using the COUNTIF formula and am trying to set an open-ended range formula (see below). When I do so, I receive the error #UNPARSEABLE =COUNTIF(Test Result:Test Result, Status1) Is there any reason this wouldn't work? I've attached …Formulas and Functions62mrsmorden
-
First post 11/26/18,Last post 11/26/18Hi, I'm running a project where I want to report our the % completion of a sub task based on the # of pieces completed. I'm thinking I need to create a formula as the % of completion functionality looks at duration vs. actual amount of w…Formulas and Functions31AndyO
-
First post 11/25/18,Last post 02/05/20Once you reach this figure of maximum cross sheet references how can you get around this. I want to configure calculations to 2030. Got to June 2025 before I got stuck. Regards SteveFormulas and Functions496Steve Moss -
First post 11/25/18,Last post 11/28/18Wondering if there is a way to sort rows of a sheet on open. Otherwise you have to set this up manually each time. If this is a smart sheet you would think it would be able to do this.Formulas and Functions64Steve Moss
