-
Copy row to another sheet by COUNT until COUNT = 0, or other Parse option
Hi folks, I've got rows that collect courses for students into the COURSES REQUIRED column separated by commas. I've already setup a formula to count the number of courses found there What I'd like to achieve is that for each student/row containing multiple classes in their required list ... parse that students row such…
-
Index Match Help
Good afternoon, I'm trying to get my Index and Match formula to work, it was working correctly and has now broken and I'm not sure why. I Have a "Weekly Metrics" Sheet I'm Trying to pull information over to the "Weekly Metrics 2" Sheet I'm trying to get the data from Weekly Metrics to Weekly Metrics 2 by matching the dates…
-
Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
-
What formula do I use to count a specific text when multiple text values are in a cell?
I have a column with a drop down where you can select multiple options for one cell. It is tracking who is affected so it can list multiple departments. I want to track by department so I am trying to figure out how to count only a specific word in a cell when there are multiple valves in the cell. The formula I am using…
-
Formula to add X years onto a date?
Hi, I have a formula that adds 1, 2 or 3 years onto a date but the return date is going to the 1st of the month. Can someone please advise how to fix this so the date is exactly 1, 2 or 3 years later? Formula I have used in Next Review Date column =DATE(YEAR([Last Reviewed Date]@row) + [Review Frequency]@row, MONTH([Last…
-
RYGG ball and task status formula based on % complete and due date
Hello! I am working on a column formula for a project plan where the RYGG ball and Task Status will automatically be updated based on the % complete and the due date. What I'm trying to solve for is: if % complete = 0 and start date is today or in the future, then stage is grey and status is "not started" if % complete =…
-
Auto populating Rows based on the number in the Qty box
Hi. Is it possible to auto populate rows based on the number I have in my QTY cell? I want when I enter a 3 in the QTY cell it automatically copies and adds those three lines. I need each of the in this case branding # to have their own lines and I do not want to have to put in all this data. Sometimes we have up to 100 or…
-
Index-Match cross-sheet reference for a Contact List column
Hello everyone - thank you for your help. I am having some challenges with an Index/Match formula that populates a Contact List type column from a cross-sheet reference. It is finding the data & pulling it back, but it is not formatting the column as a "contact" - it looks like plain text (no contact "circle") This is my…
-
Formula help if statement but want to include if blank
I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far =IF(CustomerName@row = "NCR Intercompany", ServiceCustomerName@row, CustomerName@row)
-
Calculating Formula help
My goal is if total number of students is 0 then it should equal number of students then in Total students the formula will be total number of students minus number of students
