-
Pulling Partial Rows Using Index/Match
Hi all, I'm hoping someone can point me in the right direction here. I'm trying to figure out the best way to pull partial rows from one sheet to another without using Bridge. Specifically, I'm trying to pull requests that were populated on a separate grid sheet through a form over to the department-wide tracker grid…
-
Cross Link without Locking Cells
Hello, I have a main tracker (T1) and a sub-tracker used for only one team with limited view (T2). I need to link the tracking cells so someone can enter data on both sheets and it show up on T1. However, on T1 I have additional lines in the same column that require updating but will be locked if I try to run a column…
-
How to get a formula to count only negatives or only positives
I have two formulas for a helper column to a metrics sheet. I made a column that counts the number of days until an order is due to arrive, and then there are two helper columns. the first needs to take those numbers and return a value based on the number. So if the order is set to arrive in 5 days, then the value would be…
-
Creating an intake form for a task sheet which has tasks and sub tasks
My team's tasks sheet has a lot of columns, other than the usual Task name, start date, end date, status etc. To make the task entry easier, I am trying to create an intake sheet. However, the sheet has both tasks and sub tasks, which make creating the form little challenging for me. I am able to enter the tasks one by one…
-
COUNTIF multidrop down values
I am trying to create a summary sheet to give me the number of values in a multi drop down list. I need the exact match. I used this formula, but it's coming back #unparseable. =COUNTIF([KSK Middle/High Testing Dates]:[KSK Middle/High Testing Dates], HAS(@cell, "October 7, 2024))
-
Help with multiple condition
I am looking for the right formula so that changing the Month does not affect the count of the previous month. =COUNTIFS({Asset Health Tracker Range 2}, "Lawn", {Asset Health Tracker Range 3}, "August", {Asset Health Tracker Range 1}, "Red")
-
How can I get a multi-select dropdown column to populate with comma separation?
I have a two different columns that are populating differently, just using simple formulae: (I took out all the error checking to make it simple until I can get it to work) =[Name]@row, where [Name] is a Contact list, allowing multiple contacts per cell, and =[Department]@row, where [Department] is a Dropdown list, also…
-
Health Icon Formula Help
Hi All - Longtime lurker, first time poster. I am attempting to add a Health Column to a smartsheet created by a colleague. I have been in the forums checking answers to similar, and tried to kluge my own formula together, but I've either missed the logic or I'm trying to do too much. What i'm trying to achieve rollup…
-
IF formula: IF x in column A then enter this in this column B
Hello All, Need some assistance with an IF formula. I want to create a formula where each month in a row is accounted for and assigned a Quarter. Q1 ( January, Feb, March), Q2 (April, May, June) Q3 (July, August, Sept) Q4 (October, Nove, Dec). Below is a part of a formula that I have come up with - let me know your…
-
In Progress Formula Not Working (Also Start Date Not Adjusting)
Hello, We had a project template set up for us that would automatically provide a status of "In Progress" if the % Complete was not 0. I made the % Complete 10% for one of the tasks and the parent didn't pick it up, so the status did not move to "In Progress". Here's a screenshot of the task being 10% complete and the…
