-
Data Mesh: Source vs Target sheets
Hi all, I'm creating a work flow to integrate a number of services that my team offers. There is a work sheet that captures all projects sent our way and assigns them to 1 to 3 services - and those projects show up on their respective work sheets via Data Shuttle. Currently - I have cross sheet formulas set up such that…
-
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…
-
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…
-
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…
-
Summing $ from Multi-select dropdown that includes text
I am running into a problem that I have not been able to find in the community. I have a multi-select dropdown column that includes text and $ values, e.g. A - $25.00, B - $30.00, etc... I would like to take the selection from the column and sum the $ values. I would then multiply that by the Qty, =( )* Qty@row. I am able…
-
I need a if else formula
I am trying to create a formula that returns 1 if the value in the cell is created, then 1 else it returns that value that was originally in the cell. =IF([Total Sessions Attended]:[Total Sessions Attended] < 1, "1", [Total Sessions Attended]@row) [Total Sessions Attended] is the column I am looking at in the formula to…
-
Multiple IF(AND(OR statements to return a value
I am trying to find the correct formula for the following: IF classification is External Hire, AND Business Title is Assistant Store Manager OR Store Manager, AND Store Format is Steady State, THEN training duration = 42 IF classification is External Hire, AND Business Title is Assistant Store Manager OR Store Manager, AND…
-
Count total of a column only if another column is not N/A
Hi, I'm trying get a count for the number of items completed in my status column but I do not want them to be counted if the Target start date is N/A. Help! =COUNTIFS(Status128:Status133, "completed", NOT(CONTAINS([Target Start Date]128:[Target Start Date]133, "N/A")))
