-
Formula to Collate Entries based on Criteria
Hi I'm looking for a concatenate type formula that will collate a number of line item updates based on their project ID. I have a sheet that contains multiple tasks for a project, each having an update. I want to collate all the task updates, based on Project ID, into a rolled up view to give one overall update of the…
-
Pull data from one sheet to another. Nothing working.
I am trying to create a column formula which automatically pulls data from a sheet called "Employee Details". I will need to do this with data from several columns but I will focus on the "Employee Name" column here. I have already created a cross sheet reference between both sheets in the Sheet Reference Manager. In both…
-
Problem retaining formulas in cells that are in a form
I have an intake log that has a form for parents of child patients to complete in order to apply for services. I have added logic that allows the user to complete the patient's address. Then, I ask the question of "Is your address the same as the patient's" (Yes/No). If yes, I want the parent's address fields to populate…
-
ranking based on criteria (RANKEQ, COLLECT)
I'm stumped with getting RANKEQ to work with COLLECT as a column formula. I want to rank a total score ("TOTAL") within each of several award categories ("Award Category"). I can make the following cell formula work (in column "Rank by award category"), and then drag the formula across other cells. =RANKEQ(TOTAL@row,…
-
How to adjust numeric format when combining cells
Greetings, Community! I am attempting to concatenate three cells containing numbers and retain the decimal places and 'thousands' comma separator. I've searched high and low for an existing solution, but not finding anything. Here's a snip of what it looks like. The '121410' is coming from the sheet grid; the other figures…
-
If statement referencing another sheet - Outcome Employees that have not submitted their time.
I am trying to capture employees that have not submitted during a week. I have a sheet (Staff that hasn't submitted) with all the employee names and a yes or no column. I would like to ref the master sheet (Standardized Time Sheet) which also has the employee name and the week ending date which is always a Saturday.…
-
SUMIFS and referencing columns on another sheet
I've been searching the community and couldn't find an answer so hoping someone will see this and help.. I have a data sheet and am creating a calc sheet for a report. I want to look at the reference sheet, identify one "type" and then sum all the $ for that one type. I have tried different SUMIF/SUMIFS and I cannot figure…
-
COUNT DISTINCT COLLECT returning 1
The following formula is returning 1 We are looking to count distinct number of customers for each site based on data from another sheet (as a customer may have multiple projects with us) These are the headers of interest in the sheet with all the raw data. The "Site" column a multi-pick column so we set up a "Site helper"…
-
Automated adding in project
Hello, I have a portfolio of about 80 projects, each with their own project sheet and all built on the same template. My organization has several functional groups (lab operations, procurement etc.) that work on their portion of these projects. These functional groups would like to start using smart sheets to manage their…
-
Nested Formula IF(NOT(CONTAINS AND IFERROR(SUM(CHILDREN
Hi There! I'm hoping I'll eventually have time to take the formulas training that smartsheet offers but in the meantime, can anyone help me write a formula that's above my pay grade? 😁 I have a formula for calculating our overall progress for a project. However, I've had to break the project down into tasks that, while…
