I have a normal/typical/simple project plan sheet: task, duration, assigned to. In lieu of having the Proj Mgr ask the engineer, how much he accomplished on the task and then putting that time into the project plan manually, is there a w…
Formulas and Functions12Joel Richardson
Is it possible to you use a COUNTIFS formula referencing multiple sheets?
Formulas and Functions9Gillian Pritchard
I am looking to embed and IF statement that includes ISNUMBER. If I keep the statements separate they both work, but when I combine them together I get and "UNPARSEABLE".
Here is my Statement "=IF(ISNUMBER([P2…
Formulas and Functions11Jason Klaver
Hi, I'm looking for formula help with the at risk flag.
Goal: If target finish date is within 7 days OR past due, and % complete is less than 100%, then activate flag. when % complete equals 100%, flag can deactivate.
Formulas and Functions18Cindy Doucet
I have a column in a sheet that I named Assigned To. It pulls a contact based off an IF statement dependent on another cell in the sheet. The formula works properly and plugs in the contact appropriately with their icon as well.
I have a…
Formulas and Functions16Joshua Chesner
Am trying to solve this query without succeeding please help .if value in cell B is greater than cell A values , divide by 2 and return answer in cell C. if Cell A value is greater than cell B value return A value in C. is the above quer…
Formulas and Functions9heze
I have a kanban board and want to limit the number of "cards" that can be in the "WIP" lane.
I also have another file where I have ABCD ranked projects, and want to limit how many can be an "A" project.
Formulas and Functions9Kalifa Telintelo
Has anyone used the Risk Assessment Matrix template and then created a dashboard summary view? I would like to create a summary like the blow that rolls up all the risks.
Formulas and Functions42Leann Gibson
So, in one of the sheets we are working on, the date for the today function always changes back and forth (a day difference). We think it's because a member of the team has a different timezone so whenever they make changes to the sheet, n…
Formulas and Functions17Wini
Trying to make a simple task management sheet, using today's date and the task status to define a Red, Yellow, Green or Grey ball.
If end date is today or later, AND status is not complete or cancelled, green
If end date is today…
Formulas and Functions15Anna Keeton
I need some help with a helper column I created to resolve an issue.
I am currently pulling together 4 non-adjacent multiple-contact columns into one string by using =[column1]1 + [column2]1 + [column3]1 + [column4]1 in a tex…
Formulas and Functions20Jae Wyld
I've built a project schedule and I'm trying to pull only the task that's "In Progress" into the parent row of that phase.
So basically my formula needs to look at the children in the status row, find the one that…
Formulas and Functions27Stacy Calhoun
I am having trouble with my formula. A portion works but as soon as I insert the IF and ISBLANK Statement it Fails. I want the formula to use the "Actual Plan Actual Finish" column and if that is empty then use the "Action…
Formulas and Functions23Rigoberto Huizar
Formulas and Functions9A Rose
I have a parent row that represents a task and the children rows vary depending on the number of days to complete the parent task. And so what im trying to figure out is what equation would look for the "last" value or the most c…
Formulas and Functions17Hunter Gade
Hello all! Is it possible to add an external folder link to your sheet somehow? A clickable link?
I.e. a path to a folder in one of my drives.
Formulas and Functions17Saramitsu
Hi - I know this has been asked several times but I cannot seem to get the syntax right on my summary formula.
I need to count the total number of agreements that are in the DIVISION REQUESTED BY column with any part of General Counsel the…
Formulas and Functions15jmoser
Relatively new to smartsheet and getting to grips with sum of the hierarchy functions
I want a formula that returns the task name for the milestone of any given task.
or the task name of the last child
any help very much apreciated
Formulas and Functions10Andy Counsell
I'm trying to make a planing scheduel starting from my ending due date. I need it to calculate automaticly my starting date. Can anyone help me?
Formulas and Functions16Compte Général
I have added 2 columns to a data sheet, one for Analyst Name and one for the Analyst Manager. I have brought in the email addresses of both of these by DataMesh.
I want to be able to apply a current user filter to a certain column whi…
Formulas and Functions27Jennifer Murphy
Hello! I have two Smartsheet's which are identical except for links are not consistent between the two...any thoughts on how to identify links that are not on both Smartsheet's? There is no way to filter to linked cells only, or run repo…
Formulas and Functions13Debra Platt
I am doing end of year summary data and am stuck. I ran a report and have lots of data - name, gender, race from rosters across multiple trainings. There is duplicate data (X individual may have attended Y training, but also Z training). I…
Formulas and Functions21em_sfcc
I have a sheet that has a column called Steps, Values Step 1, Step 2,...Step 10
From another sheet, I want to count how many Steps happen in a Stage (which contains a number of Steps)
I would like a count formula that looks at the Steps in…
Formulas and Functions145Frank Falco
I have the following formula that only works if a time is entered hh:mm pm. I can't seem to find a way to get this to accept PM. Only works with pm.
=IF(FIND("pm", [Tech Arrival Time]@row) > 0, "P", "A&qu…
Formulas and Functions15Sharon Castiglia
(Image) I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is great.
It now red …
Formulas and Functions16Ruth Potts
Is there a way to automate those columns so they can recognize a pattern? For example. If I create a task that happens every two weeks and schedule the first set of dates, is there a way to automate that, so if I pull the cells down, it ca…
Formulas and Functions13Krista Cornew
I've built the rolling 12-month grid below, which will be referenced elsewhere in this summary sheet.It works, but this could be cleaner. I know I could remove the "helper" row (row 1), but this is how I worked it out, so I kept …
Formulas and Functions19Marvin Daniels
This discussion was created from comments split from: Count of cells in a date range.
Formulas and Functions12System
Keeping track on vacation time I need to convert dates to weeks and then again to an overview with checkboxes.
In order to get a list of weeks [c_weeks_listed] (later in use with FIND) I have come up with the following IF-formula which wor…
Formulas and Functions12HOFF
I have a multi select dropdown column where users can select phases of a job they have experience in. For this example, let's say they have the options of "Pre-Execution", "Execution", and "Closeout". I want t…
Formulas and Functions23Alan Donovan