-
How do I fix my IFERROR(INDEX) formula to pull data from a single sheet?
I'm trying to pull publishing locations from a column in a sheet using Project ID. The first part of the formula and last part of the formula seem to be okay, I get the "Edit" option if I click on them, but the MATCH portion is giving me the "reference another sheet" message. Here is my formula: =IFERROR(INDEX{CE&T ARCHIVE…
-
Add Months to Date formula?
I've read through a lot of the help topics and others' questions, but haven't been able to find a simple solution to my issue - which I think is fairly simple. I'm trying to add a certain number (Varying) of months to a start date to produce an end date. I have a start date column (which is a date column), a column that…
-
Master Column to Reference Answer from Multiple Columns
I am trying to find an equation that will help me reference text found in multiple different columns to a master column. My "master column" is the column titled "SO Program". Based on the answers being submitted from my form, I would like the answers/text to to populate to the 'Master Column'. So if 'SO Malaysia' is…
-
Formula for finding the column name?
I have a set of data where I am trying to do 2 things: Find the top 5 highest values in a row. I used a LARGE formula to find the values in the 1st-5th highest spots (seen in rows 9-11). Find the name of the columns where the 5 largest values reside, without having to manually look at them. This is the one I can't get to…
-
Count If with Symbols?
I am trying to label the overall health of my projects If all symbols on my range are green, I want the overall cell to have a green symbol. If one or more symbols on my range are yellow, I want the overall cell to have a yellow symbol. If one or more symbols on my range are red, I want the overall cell to have a red…
-
How can I use Index Match Match
I am trying to use index match to pull a contact name from the last person who worked on the project. This one works which is on the same page but I need a version from a different page =INDEX([ASSIGNED ENGINEER]@row, MATCH([JOB NAME]@row, ""), MATCH([JOB NAME]@row, "")) Im following the same rules index the Range of…
-
How to identify the latest record submitted via a form among all entries by the same submitter?
My smartsheet dataset is comprised of form submissions. Businesses are required to submit the form monthly, and I need to assign a "red" color to businesses who have not submitted a form in the last 60 days, and "yellow" to businesses who have not submitted a form in the last 30 days. I do have a separate sheet listing all…
-
Count & Collect giving Error
I have multiple Metrics sheets where I use essentially the same formula to collect information. For some reason I am not seeing, I am getting an error with this one. =COUNT(COLLECT({Row ID}, {Category}, $Label@row, {Wave}, W1B$1)) The intention is to collect the number of Tickets assigned to each category during Hypercare…
-
Dynamic Column Reference
Hi! Lets say I have a basic formula like this in a "budget" column: =SUM([Week 1]@row:[Week 10]@row) And I also have a cell in a helper column that includes this formula: =WEEKNUMBER(TODAY()) Is there a way of [Week 10] changing to [Week X] based on the number in the week number cell? I have a column for every week of the…
-
Formula Copy/Paste Issue
I have the below formula to extra a Quarter based on my column "Expected Close Date". The fiscal year begins 10/1. When I copy the formula to other rows it displays the same number (i.e. January showing as Q4 when formula is pasted when it should be Q2. =IF(MONTH([Expected Close Date]@row) >= 10, "1", IF(MONTH([Expected…
