-
Add Two Summary Fields To A Cell
Hello and thank you in advance for any help you might be able to offer. I'm just getting going in smartsheet. I've built my first sheet with Summary Fields (brief pause while I pat myself on the back). I'd like to take those summary fields and auto-fill cells in the sheet. I've figured out how to do it with one summary.…
-
Return all rows that match any names in a master list
Hi! I have been trying to return set of rows from a data set (separate sheet) with one of the columns (Action Owners) being the criteria range. However, the criteria is not just one value, but I want it such that if the name in Action Owner matches any name my "master list" of names (separate sheet), it will return those…
-
Total Price Column for Parent is summation of Total price of Children
Hi, Can I know what formula to use in order to achieve Total Price Column for Parent is summation of Total price of Children. When I did convert to column formula it came with 0 value. I had used =SUM(CHILDREN()) and also the column properties is Text/Numbers. Thanks in advance. Krunal
-
Populate a date based on column status
Within the grid, there are 3 columns with dates that are updated by various teams. There is a 4th date column that I will need to read the other 3 columns and choose one based on what the "Status" column reads. If the status@row is "Complete" or "Not applicable", then I will need the "Steve Report Date" column to pull the…
-
I think INDEX MATCH function? Help Please
Hello, I am looking to pull in information from one sheet to another in a column formula that matches certain criteria in one spreadsheet. Below please find a more detailed write-up of what I am trying to do. In screenshot one I am tying to create a formula that takes the "Total Committed Hours This Pay Period" from…
-
SUMIFS with External reference to a single select dropdown
Hi, My apologies for my lack of brevity, I'm not even sure how to word or ask a question about this... I am obviously pretty new to Smartsheet. Objective: To be able to flag projects where the assigned resources don't have a lot of experience with the specific project type. Context: I created a sheet (SHEET A) that's…
-
Day counts
Hello, I am working on formulas to gather our end date/past end dates for example I want to capture 45-day, 30-day, 15-day, 10-day and 5-day I do not care if it is in a pie or metrics just not sure the best way to gather the data with there already being a formula in the column to calculate those days then present them on…
-
Why am I observing this odd behavior with a "Created (Date)" column?
I think I've found a bug. I have a column that is of type "Created (Date)" called "Date" and another column called "DATE TEXT" which is a text column. DATE TEXT = Date + "" DATE TEXT is calculated by appending a null string to Date. I have noticed erratic behavior in another sheet that references this column, and I believe…
-
Nest IF Statement
Hello, I could sure use your help. I have multiple nested IF statements that I cannot seem to get to work correctly. Here is what I am trying to achieve: IF Date is Blank, Leave the cell blank IF MONTH = 1, return Jan IF MONTH = 2, return Feb, etc, etc. I can get the blank part to work but it won't seem to go past that to…
-
Database Duplicate entries (Date & Item Based)
Hi All, I am struggling with a Item & Date based duplication formula. 1) For ease of reference I have filtered the database on Item "WL04". Various "ITEMS" with unique id's gets submitted into this database. 2) There can only be one entry per "ITEM" per "DATE" 3) As can be seen on the screenshot there are two entries for…