-
COUNTIFs Help.
Hello, I am trying to count how many times the names appear in the "Career Counselor" column, these are just a few examples, we have a few hundred different names and thought a formula would be easier. I have tried different formulas combinations using "COUNTIFs" without any success, please help. Thank you!โฆ
-
How can I show Today, where someone stands within the graph?
Hi Community, I am trying to build something that will show %complete, desired %, AND where the trainee stands in comparison to the milestones all in one graph. From the progression status indicators, I have a few items that show some data. From the trainees start date and selected target finish date, I have made anโฆ
-
Speed of Cross Sheet References
Hello! I'm working on a project where I use a lot of large cross sheet references, and it's sometimes very slow to update everything. I have one big summary sheet with 50 columns that are mostly vlookups to pull in data from other sheets. I want to reference the data in the summary sheet, and I was wondering if the sheetโฆ
-
Adding business days to a calendar date
Hi team - I have several date columns but need to create a formula that adds a number of business days to a date. An example would be: Column 1: Today's date Column 2: Column 1 (Today) + 10 business days Column 3: Column 2 + 10 business days Any help would be greatly appreciated.
-
Retain Date format when pulling data from another cell
I have one column [End Week Date] that uses a formula to provide the Monday Date of the week a task is supposed to end. This formula works. I updated the [End Week Date] date format to YYYY-MM-DD. My issue: I have another column [End Date Week Text] that I use the formula: ="Ending Week Of " + [End Week Date]@row Expectedโฆ
-
IF/AND formula with Children
I am trying to create a formula that returns different values based on if a value is in one of the children cells and if a checkbox is checked. So what I want to happen is if the checkbox is not checked in the row for "F/T Cycle 3", then return the value "F/T due", and if it is checked return "F/T complete". I got theโฆ
-
Auto-populate project phase in another sheet
Hope someone can help me with this question.... I would like to auto-populate a project phase (i.e. initiate, plan, execute, monitor&control, close) in another sheet based on completion of phase in project schedule. In essence, when 100% of the tasks are completed for a phase (let's say plan) in the schedule, i would likeโฆ
-
Splitting a list of contacts
I have a formula that pulls contact names using a certain condition. The problem is that in some cases it returns more than 20 contat names that is the limit for contacts in a cell. I am looking for a way to split the result in 2 or 3 coliumns so any column will not have more than 20 contact names. Any ideas on how toโฆ
-
Forecasting Scopes of Work
Hello all! I am looking to do some forecasting! I have Data from a third party application that I bring into smartsheet as its own data. It has a Start Date Column, and End Date Column, a Duration Column, and a scope of work column. The Scope of work is consistent from Row to row, depending on what the scope entails. I amโฆ
-
Does NOT contain formula
Hi everyone. I am trying to come up with a formula that provides a solution to this: Column "Product" contains a multiselect dropdown with X, Y and Z as options. Colum "Type" contains a dropdown list with multiple selections available, but needs to reflect "N/A" IF "Product" column as any combination of selections thatโฆ