-
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")))
-
Need a SUMIF formula Contains or HAS for Category fund to total Budget in referenced sheet.
I need a SUMIF formula that will sum all Cat's in the identified operating budget. I thought I could use the CONTAINS or HAS but its not working. The category (not purple Budget Category) will have a number after but I don't need that number. The code in Cat is the letter (R, TO, E, TI) I need so it sums the revised…
-
Formula woes
Fairly new to Smartsheet and I can't get my formula to work, this is what I am trying do: If Due Date in Children row is less than today and Status is Not Started "Red", In Progress "Yellow", Done and in Review "Blue", Complete and Closed "Green". Thank you in advance!
