-
MIN(COLLECT( function issues
I know I'm going to kick myself when this gets resolved, but I'm having a bit of a brain fart right now. I'm trying to get the lowest non-blank value in a particular range (columns A-E). [A]@row=18, [B]@row=16, [C]@row, [D]@row, & [E]@row are all blank. All five rows are products of column formulas. Basically, there are a…
-
Date minus # of days to get new date
I am trying to have the Drop Dead column subtract 42 days from the Final Confirmation Date. I have the Drop Dead column setup as a Date Column and have tried doing this formula, but am getting an "Invalid Operation" error. Can anyone tell me what I am doing wrong? And thanks in advance.
-
Show Duplicates Based on Multiple Columns
Hi, I was looking for a solution to showing "Duplicate" if the combination of ColumnA @row and ColumnB@row of the same row appeared more than once. After taking bits of advice to similar problems in the community forum and reviewing the Smartsheet functions list, this formula solved my problem. I thought it would be worth…
-
Stacked IF Statement Using AND and OR
I'm trying to write a formula that evaluates three columns of dates and pulls in the value of a fourth column (MWh@row) if each of the first three column's dates have already occurred in the past or will happen before the end of this year, and I'm not having any success. I keep getting an "#INCORRECT ARGUMENT" error. Can…
-
How Can I Combine Multiple Percentages Into One Cumulative Percentage?
I'm working on a project that has multiple components connected to the overall goal. To better know where we're at, I've created a done category to track progress in a percentage based on when a new box is checked. To accomplish this, I used the following formula: =ROUND(COUNTIF(Done3:Done8, 1) / (COUNTIFS(Done3:Done8, 0)…
-
Auto-populate parent/child rows in a separate sheet?
Hello! I was wondering if there was a way to have certain column data automatically transferred to another sheet. Once that data is transferred, I would like for that transferred data to automatically populate into an existing parent row (if the account name matches). Example: Sheet 1 is a request sheet that is auto filled…
-
COUNTIF by Month in Date
I've always struggled with calculating total count by Month; i can do it for every else but when you throw in dates, it throws me right off. Essentially what i am trying to do is calculate on another sheet the amount of travel done within the month of March This is the formula i am using, but it comes back with 0…
-
Formula working for one data value but not another
Hi Community, I have a sheet that contains, among others, columns titled "Priority" and "Contract ID". Multiple rows can have the same Contract ID and the same Priority. Priority values are 1-2-3 and restricted to dropdown list values only. To collect the number of unique Contract IDs that are Priority "1", I have this…
-
Need Help With Date Calculation Formula
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
-
How to create a day countdown from starting date
I am looking to have my sheet track the number of days remaining after a beginning date entered in a column (labeled Conversion Date). I need to know how many days are left from a total of 90 days.