-
Drawing row linked data into another sheet together?
Hi All! So I have a sheet with a list of tasks, a checkbox for completion and a due date. In one of my other metrics sheet, I am trying to generate a list of my top 5 overdue tasks. I have managed to get a list of the most overdue dates with a SMALL(COLLECT...) function which will only count dates that are not listed…
-
Formula Assistance - Duration of Activity at Specific Rate
I hate math, so am asking the Community for some help. Looking to build what I think should be a reasonably simple formula for someone that doesn't hate math. Here's the Word problem: We have equipment that scans files for malware at the rate of 77,000 files per day. Apparently it doesn't matter if the file size is big…
-
SUMIFS for multiple criteria
This should be fairly simple, but I am spinning on this syntax. Trying to sum my "Invoiced" column if the Year Column = "2019" and the Type Column = "Expense". I have tried a few variations, but this is what I think should work? =SUMIFS(Invoiced:Invoiced, Type:Type, Expense, Year:Year, 2019). I have tried quotations around…
-
IF(OR(ISBLANK) Statement
I am trying to set a colored dot to Green if the project is on time, Red if it is late and Yellow if it is not started ([Date Completed] = blank). The Red and Green work, but I cannot get the yellow dot. Any help would be greatly appreciated. This is the formula as it stands. =IF(OR(ISBLANK([Date Completed]1, "Yellow"),…
-
How to Cross Reference Data from Another Sheet
I'm trying to link data from a column in one sheet to the similar column in another sheet. What is the best way to do that? I can't seem to get the VLOOKUP formula to work properly. Thank you.
-
Nest IF statement
Hello! I need some assistance with a nested IF statement. I am attempting to select a contract category based on expected amount of the contract. Everything seems to work properly except when letter values are included in the contract cost which I was hoping to return a value of "Other". This is the formula I am using:…
-
HELP! Summary Report to pull from different sheets based on multiple drop down selection
Hello! I am new to Smartsheets and am trying to build a Summary Report based on drop down selections and data from various sheets. I have a TON of data and too many cells so I've had to spread it out on a sheet per month. I have two drop down selections. One is to select the month and the other is to select a division…
-
Keeping Formulas When Downloading to Excel
Hello, I found online that it says when you download a sheet into an Excel sheet that it does not keep the formulas as they are different. Now just in case, I thought I'd ask: Is there a work around for this at all? Is there absolutely no way to keep your formulas when you transfer them to an Excel?
-
Only excluding the first weekend
Hi, I'm currently using a formula to spit out a certain number of days between two dates. I want to exclude the first weekend if it falls within the first 3 days, but otherwise include it. Currently to exclude weekends entirely I'm using =NETWORKDAYS([SALE DATE]21, [OUTPUT DATE]21) - 4 I'd like the formula to work like…
-
How do I Subtract a series of days from date column?
I need to calculate a series of dates for a newsletter production cycle. I want to take the Expected Release Date ie: 25 Aug 2019 and in seven column cells, beginning with ten days from the Expected Release date, then show 8, 7, 5, 4, 3, 2 days calculated dates from the Expected Release date. I can perform this easily in…