-
Summing a Multi-Select
I'm trying to figure out an easy/dynamic way to sum a column. Right now, I have Column A in Sheet 1 that is a multi-select. I want to lookup the result of that multi-select in Sheet 2, and total the values from Column B. So I know how to do it manually (i.e. - by spelling out all the values using FIND () or HAS ()) as part…
-
I am using VLOOKUP to pull data from one sheet another. I am getting #INVALID REF
THIS IS THE SOURCE TABLE THIS IS THE TABLE THAT IS BEING UPDATED WITH THE VLOOKUP This is my formula =VLOOKUP([Materials Description]@row, {TDO Material Cost Tracking Sheet All Values}, 3, 0)
-
How can I get the status of a parent row to update when all child rows are blank?
I'm trying to write a formula for: If all child statuses are Passed then parent status is Closed If all child statuses are Passed or Retest Passed then parent status is Closed If all child statuses are Not Started then parent status is Not Started If child statuses are blank or Not Started then parent status is Not Started…
-
If and statements
I would like to create a formula that will check the “MISSED” box if the “# OF VISITS LW” is less than the “Tx PLAN” number. But I would like to have the “# OF VISITS TW” supersede the prior. For example, If the “# OF VISITS TW” is equal to or greater than the “Tx PLAN” number, the checkbox would be unchecked or if the “#…
-
Using SUMIF with criteria to track weekly cashflow
Hi all, Basically, I'm looking for a way to track cashflow so that our Spending from week to week never outweighs the Invoiced AMT that we've collected up un. I have very little experience with formulas, so I've scoured the forums but haven't had any luck. I currently have a project spreadsheet called Schedule - Flares…
-
RemainingBalance to show on Source Sheet
Hello All! What is the best way to maintain a remaining balance? In my scenario, I want to show the remainng balance after each new invoice record. INVOICE SHEET I tried the following in the Remaining Balance field: =[PO# Award Amntt]@row - SUMIFS([Inv. Amnt]:[Inv. Amnt], Vendor:Vendor, =Vendor@row, [FYar]:[FY], =[FY]@row,…
-
COUNTIFS
Hi, I'm trying to write a COUNTIFS formula and keep getting errors of "INVALID REF", INCORRECTARG or "UNPARSEABLE." I'm new to SmartSheet and can't figure out my errors. Here's what I'm trying to do: Create a bar chart to track status of individual products as a whole. I have 8 different projects at various stages. I'd…
-
Vlookup help
Good morning, I've tried to create a countif & vlookup formula without luck. I would appreciate any help! I have linked the attendance sheets from several committees into one sheet. I would like to sum how many committees each organization is participating in (participation and return that value in the "# Committees…
-
average progress depends on criteria and vlookup
Hello all, we are trying the following: In a new sheet we want to reproduce some information from the source file using the VLOOKUP function. So far so good. Now the question is, if there is a formula, which from the Children lines outputs the average progress, where the lead is called "Kunde". There can be several lines…
-
Parse information in a single cell into their own columns (text to column)
I have a single cell that contains the following: Lead Company Person: [UNIQUE NAME] Legal Tracker Name: [UNIQUE NAME] Legal Tracker Number: [UNIQUE NUMBER] I would like to parse the information after the colon into their own rows. In Excel I would use text to column, but that's not an option in Smartsheet Any ideas on the…
