-
I'm trying to combine these 3 Sumifs into 1 column formula...is this possible?
-
Formula Needed For Combining Rows with Exact Values in Separate Sheet
Hello Smartsheet Community, I have a compliance tracker sheet that captures employee's HIPAA and FEMA certifications. I have been tasked with creating a dynamic view for their immediate supervisors. I have two separate views for FEMA and then HIPPA. However, I also have employees who have submitted separate reports for…
-
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…