-
Count/sum only if one of children is a specific value and scope
Hello everyone, I was wondering if someone can help - I would like to do some financial departmental metrics in terms of revenue. Now, I have a sheet with about 300 different projects and would like to create another sheet where I will only see the sum of the revenue/totals for each of the 3 columns (as below). My costs…
-
Help with Counting for specific value within cells
I'm trying to get a count of the number of cells (within the column Card_StartDate) that have a date of less than 12/31/21, but only when an adjacent column (LaneTitle) has cells with content that contains 'Parent' (parent can be anywhere within those cells). I'm completely lost on this and can't find what I'm looing for…
-
Nested IF/AND or Something else??
Hi all, I am working on a formula to determine the Duration of a Build Phase so that I can use it to calculate the Status of a build. There are several criteria required to determine what Schedule to use. Once I have the Schedule I just need to know the Duration for the Phase it’s in. I’ve built nested IF/AND statements in…
-
Cross Referencing Sheets
Hi, We want to create a sheet that cross references another sheet and only pulls in data relevant to the partner with whom we are sharing the sheet. The reason we do not want to use a report for this use case is that you cannot hide the comments from a report and we do not want them to see the row comments. Please advise…
-
VLOOKUP for numerical values
Hi All, I am using VLOOKUP to retrieve numerical values from another sheet, the formula works, however when I have '0' in a cell, it pulls '1' also, which is the true value of the VLOOKUP. When I use the same logic with excel it works w/o any issues & brings the '0' value. What should I fix to get the same results? Thanks…
-
Flag formula?
Trying to use flag column...if date is within 3 days = flag, if not, or blank = no action. Below is the formula that is not working. What am I doing wrong? =IF (ISBLANK([Submit by]@row)), 0, =IF([Submit by]@row <= TODAY(+3)), 1 Thanks!
-
Deposit summary report vs. bank statements
Hi, We're trying to create the following project. I would appreciate getting some input on how to program it correctly. As a healthcare billing company, we post all account receivables to the patient's ledger. At the end of the month, we need to tie out the deposits posted to the bank statements to confirm that every bank…
-
Formula Quesiton
I have 2 columns - one Engagement and one Desired Engagement - If the two columns are not equal, I want the cell color to be yellow as an indicator. If the two columns are equal then, do nothing. How can write that formula in smartsheets ( since I haven't figured out a way to do it with conditional formatting)?…
-
Automatically update Start and Finish dates with new week
Hi, Does anyone know if it is possible to automatically update Start and Finish dates to the new week once it hits Monday? For example, I think the formula should somehow state "When the date changes to XXX (Every Monday), change Start and Finish to Today and Today (+5)" Not sure if this is even possible? It would save my…
-
Patti P
Good morning, I would like see if you could help me with a formula…. Below is what I have and it works, but I want it to return 0 if the [PO Qty] / [Work Order Qty] are empty cells… I have tried everything I can think of….. SUMIFS, IFERROR, ISBLANK…etc…. =SUM([PO Qty]@row / [Work Order Qty]@row * 1.0) Any suggestions?