Formulas
Discussion List
- I'm working in a smartsheet that combines data from other smartsheets using vlookup formulae. I've written a column formula to add the values in two of these vlookup columns and in some of the cells I…
- I want to set a formula that will index match the value(s) of a cell with a reference list of group name and associated contact information. Is this even possible? I have Sheet 1: list where each row …
- Is there a way to set up a formula that will move project status "completed" from under one parent row to another parent row named "Completed project" once the project status has been selected as comp…
- Hi, I would like to build a formula with the following logic: "Due Date = 3 BUSINESS DAYS prior to Deploy Date." Building a "3 DAYS prior formula is simple enough, but I'm wondering if anyone has solv…
- Hello, my formula stops working after it gets through 8 rows. I have a picture below where I'm just testing out 30 rows but I need this to work for about 4000 rows, however I can't figure out why it g…
- I am trying to see when a segment is fully completed. Our segments can be broken out into subsegments, and they can have up to 5 subsegments, indicated by the segment number followed by a "—1", "—2", …
- Hi, I am creating bar chart showing the names of task owners and the count of tasks assigned to them. I achieved this by listing the task owner names in my metrics sheet and getting the count by using…
- Hi All, I have a grid which will be used as a timeline function for market planning. I want to only see the parent rows on the timeline so I have tried to set up a formula to checkbox if parent row an…
- I am writing a 'difference' formula…the sum of cell 1 minus cell 2 is the difference. Easy. HOWEVER, if the value for cell 1 = 0 I want to return just the value of cell 2 and not subtract and get a ne…
- Comparing Employee names from FORM (no sign in required) in sheet with the Employee contact list Formula ? I have a master sheet that gathers: training Name and attendees names. i will like to generat…
