-
Using COUNTIFS, and/Or
Hello! I am trying to total anything from a sheet that is BLANK in "Supplier Email" AND Priority is HIGH AND, IF any of the following are checked: Completed (AP) Invite Sent Will Not Use Using the formula below, it doesn't seem to work. =COUNTIFS({Supplier Email}, <>"", {Priority}, [Total Suppliers]@row, (OR{Completed…
-
Inventory Automation - How to subtract cell data from one sheet to another by matching SKU#
I would like to subtract the quantity from my "Inventory Pull Log" from my "Inventory Sheet", how would I go about doing this? This is the Inventory Sheet where I would like the subtraction to take place: And this is the sheet that I would like to reference to subtract the quantity from:
-
Planned Dates vs. Actual Dates with Date Variance and Gantt Chart
Good evening Smartsheet Community, Question 1 - Does anyone know the formula I would use for the "Date Variance" (variance between planned and actual) column to populate? Question 2 - I have set the baseline of the project, however when I populate the "Actual Start Date and Actual End Date" there is no visual change on the…
-
Copied Rows do not automatically update in a Rollup Sheet
I am going to ask this questions as best I can.... I have a sheet that I input information. Based on a value from a column, I automated it to copy that row into what I call a ROLL-UP SHEET. I then created a NEW SHEET with some new columns as well as some columns from the roll-up sheet. I did cell linking on the columns…
-
Help with a Formula
Good Morning - I'm hoping someone can help me with the following formula. I have a column which indicates if a task is - In Queue, In Progress, Completed, Late. It is set up as a drop down column type. I'm trying to write a formula that would populate this column based on the % complete and the start date. Here is what I'm…
-
Help counting cross-sheet formulas, references, cells
I have a master sheet with 1,400+ rows (and growing each day). I have a summary sheet where I cross reference entire columns from the master sheet. In the summary sheet, I have a formula with multiple conditions that references 5 different columns from the master sheet (aka I have 5 different cross-reference ranges). But…
-
Count the number of non blank child cells
Hi! The sheet contains the following hierarchy: There are formulas (COUNT(CHILDREN())) in the blue cells of the Missing study column. I need to count the total number of white (child) cells. In this particular case [10] should appear. What the formula should look like? Thank you in advance!
-
Addresses into a field on form
Hi all, I have a form that includes "Location" field. Instead of type the entire location, I want to know if there is any way to connect the addresses directly from google maps or other webpage based on formulas or something. So, when an user types the address in the form, Smartsheet can give it the location list from maps…
-
Multiple IF's the way to go ??
Hi all, I have a column named "Site Name" this column is a drop-down single select with all our site names (approx 20 different options) for the sake of this post I will call them Rome, London, Paris, Tokyo, New York, Milan The user selects the site name via a form and this is reflected in the cell in the appropriate row.…
-
Index/Match
in sheet1 pulling data from sheet2 Sheet2 is 49 columns, set up a reference for column 2-49. not all cells have date in it. when i do the match, i thought it would pull up the row number, on the index - i would tell it what column to pull the data from. the date giveing me is from the next row. the results are not giving…
