Formulas and Functions
Archives for February 2020
Discussion List
-
Is it possible to add dynamicaly a line ina summary sheet if a new sheet is created in a folder?QuestionAnswered - Pending Review emmanuel edon 22 views 8 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/29/20,Last post 03/02/20Hi there, i manage several projects. Each project is in a individual sheet. I created a summary sheet to gather information from projects. When i create a new project in a folder, i wonder if it is possible to add this new project inside t…Formulas and Functions228emmanuel edon -
Excluding Multiple OptionsQuestionAnswered - Pending Review CTSr 11 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/29/20,Last post 03/02/20I am having a real challenge with a particular function. I'm thinking someone will know this right off the top of your head. =SUMIFS({Digital Marketing Workflow- Total Hours}, {Digital Marketing Workflow- Priority}, <>"Sub-Cate…Formulas and Functions111CTSr
-
IF Statement helpQuestionAnswered - Pending Review DMS_2020 2 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/29/20,Last post 02/29/20So, I am trying to create a column that adds the Student ID, when the Student is Named. This way I can make my reports de-identified. From a workflow standpoint, Teachers use a drop down for the Names on a Form and then enter Student Progr…Formulas and Functions21DMS_2020
-
Accepted Answer emmanuel edon 35 views 6 comments 0 points Most recent by emmanuel edon Formulas and FunctionsFirst post 02/29/20,Last post 03/09/20Hi there, I need to know if it is feasible to obtain this formula : In a sheet, i can choose several option from a list of value ( checkboxes). If option A is checked, i add 1.5 days for ex. If i choose B, i add 1 day. If i choose A & …Formulas and Functions356emmanuel edon
-
Using VLOOKUP for Approval Requests Across SheetsAccepted AnswerAccepted Answer Darin Smith 59 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/28/20,Last post 03/09/20GOAL: 1) Have a secure and error-free VLOOKUP on Sheet B and 2) Run a multi-level approval request automation on Sheet B. DETAILS: I have 2 sheets. Sheet A tracks contracts. It has columns for individuals (contacts) who are designated appr…Formulas and Functions593Darin Smith
-
Answered - Pending Review BJ Patnode 29 views 2 comments 0 points Most recent by BJ Patnode Formulas and FunctionsFirst post 02/28/20,Last post 03/02/20I know you cannot use a formula in a "% Complete" field. Is there a way to update "% Complete" from a formula in another column (something like a "helper" column)? I have a "Task Status" column wit…Formulas and Functions292BJ Patnode
-
Accepted Answer Ann Foley 18 views 3 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 02/28/20,Last post 03/08/20Hi, I'm trying to make a formula that says 2020 Experiential Audit minus 2019 Experiential Audit = value in Experiential Audit YOY change...but only if there is data in both 2019 and 2020. See my sheet below. I think this is an IF formula…Formulas and Functions183Ann Foley
-
Answered - Pending Review Richard King 54 views 1 comment 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 02/28/20,Last post 03/02/20Hi , I have two sheets, sheet 1 holds fixed data and sheet 2 is populated via a form. I want a cell in sheet 2 to return data from a cell in sheet one when two column values in sheet two are matched to two column values in sheet 1. Is this…Formulas and Functions541Richard King
-
Duplicate value formulaQuestionAnswered - Pending Review Heather Druckenmiller 49 views 1 comment 0 points Most recent by JReisman27 Formulas and FunctionsFirst post 02/28/20,Last post 02/28/20I am trying to use a formula that will place a check mark in my duplicate check column if an invoice# in column 8 is a duplicate. I was using the =IF(COUNTIF format but it doesn't seem to be working for me Any recommendations This is th…Formulas and Functions491Heather Druckenmiller
-
Formula for % of checked boxesQuestionAnswered - Pending Review Alisia Gill 26 views 3 comments 1 point Most recent by Genevieve P Formulas and FunctionsFirst post 02/28/20,Last post 03/02/20I'm requesting help to create a formula that will calculate the % of the checked boxes that are checked vs unchecked for calendar year with a project status of complete?Formulas and Functions263Alisia Gill
-
sequential lettersQuestionAnswered - Pending Review Eric Figge 36 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/28/20,Last post 03/10/20I have a sheet where I have parent and child rows, and I would like one column in the child rows to have sequential letters. I have a picture here. I have a parent/child column that would normally be hidden, but I count the number of chi…Formulas and Functions365Eric Figge
-
Accepted Answer Katie White 62 views 5 comments 1 point Most recent by Darren Richardson Formulas and FunctionsFirst post 02/28/20,Last post 04/20/20Can someone help point me in the right direction of where to go to submit a ticket for this? For four rows on my sheet (Row 1, 3, 4, 5) every time I save my sheet those rows update the modified date, even though I'm not touching those rows…Formulas and Functions625Katie White
-
Accepted Answer Tyler12345 45 views 10 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/28/20,Last post 03/03/20Hello, Apologies for yet another basic question, but I'm having troubles wrapping my head around how to get a formula to behave a certain way. I'm still working on a PTO manager tool (requests PTO, automated approvals, and auto calculation…Formulas and Functions4510Tyler12345
-
MULTIPLE AND ON MULTIPLE COLUMNS wANCESTORSAccepted AnswerAccepted Answer ncanales 16 views 2 comments 0 points Most recent by ncanales Formulas and FunctionsFirst post 02/28/20,Last post 03/02/20Hi there... really need help 😯 I have a list of actions, all actions are either a PARENT action (Outdented) or child actions (Indented). I added a column with =COUNT(ANCESTORS()) to have 1,0 depending on the case. I have another column wi…Formulas and Functions162ncanales
-
Answered - Pending Review Adam Fleming 17 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/28/20,Last post 02/28/20I'm receiving a circular reference warning when all I'm doing is pasting as links to copied cells. Any ideas for why this is occurring when many other places in the sheets are able to be copied in this same manner?Formulas and Functions171Adam Fleming
-
COUNTIFS with other IF criteria and referencing other sheetsAccepted AnswerFirst post 02/28/20,Last post 02/28/20Hello! Context: I'm leading the charge on tenant migration for a datacenter over 7 weeks. There are 10 teams (each with their own inventory sheet) and hundreds of services among all the sheets. Goal: track completion metrics across all te…Formulas and Functions431kolfinna
-
Force upper case on a columnQuestionAnswered - Pending Review Juan-JLC 69 views 5 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/28/20,Last post 03/15/20Hello Everyone, I got a question. Is there any way to force upper case on a text column? I have a column where users enter information using iPads and it will be very helpful if the cells will automatically force to have upper case font i…Formulas and Functions695Juan-JLC
-
Limit number of rows in Smartsheet?Accepted AnswerAccepted Answer Michael Tuccillo 25 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/28/20,Last post 02/28/20Hi there, Is there a limited number of rows in one smartsheet? If so, what is the number? Thanks! MikeFormulas and Functions253Michael Tuccillo
-
Answered - Pending Review Stephanie Bauder 27 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/28/20,Last post 02/28/20Is there a way to return values in a cell if multiple criteria is met? I would like to track the amount of time our Onboarding Coordinators spend on tasks for each Country. So when they create a contract in Austria it takes 60 minutes but …Formulas and Functions273Stephanie Bauder
-
Answered - Pending Review Stephanie Bauder 60 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/28/20,Last post 03/01/20Is there a way to have the Sheet Summary auto-fill multiple values based on a selection from a drop-down field? I would like to have "country" be the drop-down select field and based on the country selected, the fields below woul…Formulas and Functions603Stephanie Bauder
-
Answered - Pending Review Kimberly Jones 23 views 6 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/27/20,Last post 03/01/20I have the following function on over 140 rows in a project plan: =IF([email protected] = 1, "Task Done", IF(ISBLANK([email protected]), "Ready to Begin", IF(INDEX(TaskCheck:TaskCheck, VALUE(LEFT(([email protected]), 2))) = …Formulas and Functions236Kimberly Jones
-
Formula to Trip a FlagAccepted AnswerAccepted Answer Michele Phillips 45 views 4 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/27/20,Last post 02/28/20Hello, I currently have a formula in my sheet that trips the Flag function in my "At Risk" Column if the due date is less than today, and the status is NOT waived. The formula below works great. However, I would like to includ…Formulas and Functions454Michele Phillips -
SUMIFS with sheet references.Accepted AnswerAccepted Answer Richard Lucas 33 views 4 comments 0 points Most recent by JReisman27 Formulas and FunctionsFirst post 02/27/20,Last post 02/28/20Hello, I've got this formula working like this. =SUMIFS({DayCount}, {EmployeeName}, [Employee Name]@row, {ReasonforAbs}, "Vacation") However when I change the criteria to "PPL / Sick" it's returning 0 when there are cl…Formulas and Functions334Richard Lucas
-
Contact List appearing as email address and not by nameAccepted AnswerAccepted Answer Silvia Rangel 84 views 3 comments 0 points Most recent by JReisman27 Formulas and FunctionsFirst post 02/27/20,Last post 02/28/20Hello, Has anyone encountered this issue? I have a contact list column and the values were entered with a name and an email, when pulling a value into a column sometimes it shows as a name (which is how we wanted to show) and other times …Formulas and Functions843Silvia Rangel
-
Accepted Answer Mary Hum 24 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/27/20,Last post 03/03/20I want to use add up costs in an AMOUNT column when the value in the CATEGORY column is SHOES and this display this in a Summary Order sheet. Can someone tell me what is wrong with the syntax of this formula: =SUMIFS({REFERENCE SHEET}, A…Formulas and Functions243Mary Hum
-
Answered - Pending Review Kitty 30 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/27/20,Last post 02/28/20Quarterly, I am required to show how many DISTINCT countries were reached by our instructors. I need a formula that would count the DISTINCT countries reached between (for example) 1/1/2020 thru 3/31/2020 (for first Quarter reporting). I'v…Formulas and Functions301Kitty -
Friendly RemindersQuestionAnswered - Pending Review David Gómez Roy 37 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/27/20,Last post 02/28/20Hi there, I have two troubles with the tool, I hope you can help me and I'll grateful for that First: I'm automatizating my process with friendly reminders, but these one e-mails their looks like a spam e-mails, I mean, the vowels with t…Formulas and Functions371David Gómez Roy
-
Answered - Pending Review noclue 26 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/27/20,Last post 02/28/20I am looking for a formula that brings over data from a column only if there is a date in another column. =IFERROR({Dallas Tracker NEW Start Date} > 1, (IFERROR(INDEX({Dallas Tracker NEW Mileage}, MATCH([SEGMENT ID]525, {Dallas Tracker …Formulas and Functions261noclue -
Answered - Pending Review RPIArchShop 57 views 6 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/27/20,Last post 03/15/20Good Afternoon Smartsheet wizards, While I am relatively new to Smartsheet and have purchased some of the learning, the Conditional Formatting is entertaining. I'd like to prove that certain cells have formulas, or not. Thank you in advan…Formulas and Functions576RPIArchShop
-
Answered - Pending Review John Kennedy 30 views 9 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/27/20,Last post 03/02/20I have a master spreadsheet with many columns (sheet1). From that, I want to create a second sheet with fewer columns (sheet2). The first column in sheet1 is 3 cells combined (=[Column1]1 + "-" + [Column2]1 + "-" + [Col…Formulas and Functions309John Kennedy
