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 …
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(TOD…
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 pr…
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 updat…
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 Na…
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 th…
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 …
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 formu…
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 …
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 Att…