-
How do I create a lookup on a multiselect dropdown column? add multiple lookup values into the resul
-
Help with counting formulas and exclusions
Hi there, I'm trying to create a formula that would count all instances where a certain option is selected from a Multi-select drop-down and then it would subtract any instances if a certain category has been selected in another column. For example: This formula gives me 13 counts: =COUNTIFS([Curatorial…
-
Formula Stopped Working
I've been using the below formula to calculate how many months have passed between dates (a single day in a month should have that month counted). It's been working perfectly for months, but recently I switched one of the columns from automatic population to manual (otherwise, no changes). It's now returning odd values,…
-
My Formula Needs Help!
Hi, I have a status column with the following value: Not Started, In Progress, Canceled, On Hold, Complete. I would like to modify my current formula to cause the behavior below: All children are Complete – Parent = Complete One or more children are Complete, In Process, and any other status – Parent = In Process All…
-
Using Formulas for Start Date/End Date in Project
Hi Smartsheet community, I am working on creating an automated Gantt chart based off another sheet that I am using to run an Agile project. It is not going well. My 'source' sheet is a grid that shows each of our deliverables and iterations. I have used an index-match formula to bring that data into the Gantt chart so the…
-
IF Formula Counting Multi-Select Drop Down Answers
Hello, I am trying to create a formula using an IF statement that will say "On Track" if there is one answer in the cell, but if there are more than one it will output "Delay". I am assuming my IF statement is counting the answers the way it is working now, however it isn't quite counting correctly and not sure what I'm…
-
Using a dropdown to pull duplicates
Hello, I have created a "helper" column to help me find duplicate entries within a row. So all of my columns are going to be drop down entries so as to avoid spelling or typo issues. If a person appears in "Faculty on PTO" I need to be alerted if they are entered in any other cell for that date. I can easily set up…
-
Rolling 90 Day Formula
Hello, I need to write a formula that will check a box if a date is in the next 90 days, and uncheck if the date has passed. What I have so far is: =IF(Start@row <= TODAY(90), 1,0) So, if the Start date is less than or equal to 'Today' or the next 90 days, then check the box. If the Start date is not in the next 90, then…
-
editing across sheets for text consistency
Hi all, I'm not even sure what to ask for, other than help. I have three key sheets that contain many of the same fields. I've (finally) figured out the Index Match formula to pull matching field in from another sheet (there was much rejoicing!) but now am needing to be able to edit the info. Is there a way to do that…
-
Count Help, Don't Know Where To Start
Hi Everyone, I would like to do a project status summary. Each parent is a school site, and the children are the projects that need completion. In the drop-down menus next to the projects I change the project status to complete when done. I'd like to create a list of all the school sites included in this project that shows…