-
How to summarize current status organized by column
Apologies for the silly question, but I can't figure out the best way to summarize or report what I need here and hoping from advice from more experienced users. We record the dates we completed parts of a project in columns (start date, draft review, issued, etc). I'd like to figure out a way to easily report where…
-
Hierarchy Formula
I am trying to create a formula to rank priority automatically. For some reason I am unable to make this work. Looking for assistance. =IF(CHILDREN([Rank Priority]@2="Red",Priority@row1), IF([Rank Priority]="Yellow",Priority5, IF([Rank Priority]@row="Green"Priority8)))
-
Identify duplicates with multiple criteria
Hi, I need to identify rows that have the same Invoice No (text column), the same Supplier Name (text column), but different Funding Date (date column) and flag the row. This is the formula I attempted that did not work: =IF(COUNTIFS([Invoice No]:[Invoice No], [Invoice No]@row, [Supplier Name]:[Supplier Name], [Supplier…
-
Minimum Date in a range of dates that is >= Today?
I need a formula that returns the minimum date from a range of dates that is greater than or equal to today's date. I use the MIN function to return the minimum date in the range but, I need the minimum date that is greater than or equal to today's date. Today's date needs to be automatically generated so I have been using…
-
Using LEFT formula for extracting a month from a full date, 0 in month missing
Hello, I am using a Left and Right column formula to extract the Month and Year from a full date column. The formula is successful, however, it is returning only the month number that is not 0. 01/12/2022=LEFT(MONTH [Date], 2) + "/" + RIGHT(YEAR [Date], 2) = 1/22 I need it to return 01/22 to ensure I can properly sort the…
-
Flash-fill a column similar to Ctrl+E function in excel
I am looking for a solution similar to the Ctrl+E flash-fill feature in Excel, or a formula to extract just what I need into another column for export. For example, I need a column that has information set up like "101 - Class Listing" to have a column lined up next to it that has the "101" extracted (all in the same row).
-
COUNTIFS using different sheet for range and month for criteria
I am attempting to get this formula in my tracker sheet to work to count all the instances in the reference sheet where a certain month in the date column occurs and the answer to a question in another column is no. This is the formula I have come up with and I know it's wrong but all of the fixes I have attempted have not…
-
Auto populate cells
I have a smartsheet named GSA EIS_MAS_Features_Services Matrix and I need to auto populate cells based on information in another sheet named GSA TAM Contract_Features_Services_Resource_Matrix. I have tried Index and Iferror but it keeps erroring out.
-
Sum Costs From Reference Sheet
I'm trying to collect the total costs on a sheet from another sheet with a particular id "JD 41195". The main sheet has all of our equipment, the other sheet has all the costs submitted from forms. I want to add all those costs together and have them in a single cell on my main sheet. Thanks =INDEX(({Equipment R&M Range…
-
VLOOKUP and #NO MATCH
Hello! I'm having a strange error using VLOOKUP with a reference sheet. Some of the fields are matching but others are returning a #NO MATCH error. I believe that all my spelling, etc is uniform across the sheets, but please review that as well. Thanks in advance for you help!
