-
Invalid Operation for simple formula
I have this formula that is returning INVALID OPERATION =IF({AMR Location} = "Baltimore Mfg", AVG({AMR Level}), "") The Location column is just text. The AMR Level is a number that is calculated from a pick list column. =IF([Level of Professionalism]@row = "1", 1, IF([Level of Professionalism]@row = "2", 2, IF([Level of…
-
Help With Remaining Work Days Formula
All, I'm in need of a formula that calculates remaining work days within a "start date" and an "end date". I came up with this: =IF(ISERROR(NETWORKDAYS(TODAY(), [Start Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row)) - which works fine as long as "today" currently falls within the "start date" and "end date". But, I…
-
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…
