-
Stop lower row automatically copying colours from row above
I have a ticket tracker template being used at the moment, and every time a new ticket comes through from the form, the new row is formatted like a header (dark infill, bold type etc.) - how do I stop this row from being formatted like a header, and instead having it formatted like a child row should be?
-
Adding an Amount from a Prior Week
Hello, I am currently trying to get a sum from two values. One of the values is from the most recent Sunday, and the other is the Sunday prior to the most recent one. I need to find the difference of them for a calculation I am using in another column. I am not sure of how to call upon the prior Sunday's value. I do have…
-
IF/AND Function Across Different Sheets
Hello, I am trying to get information from one sheet to populate another sheet. The formula I am trying to use is: =IF(AND({Equipment} = "MIGU-1", {Status} = "Open"), "Deployed", "Available") I get an #Invalid Operation error. On sheet 1 is the data I'm trying to separate out... using the "Type of Equipment" column and the…
-
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…