-
IF, THEN formula that references a checkbox field and a date field
I'm trying to write an IF, THEN formula that references a checkbox field and a date field, but I keep getting errors. Here's the logic: If the 'EMDS' column is checked, then calculate the 'Date Needed' column minus five days. If seems simple, but it may actually be too complicated for the system since it essentially…
-
Multiple IF/And statements in one column
I am using the function: =IF(AND(Impact@row = "Low", [Angela Approval]@row = "Approved", [Billye Approval]@row = "Approved", [Jason Approval]@row = "Approved", [Michael Approval]@row = "Approved", [CAB Approval]@row = "Approved"), "Approved"), IF(AND(Impact@row="Regular",[CAB Approval]@row = "Approved"),"Approved") When I…
-
Automated date due to change in dropdown list
Hi folks! We're trying to set up a sheet where we are able to automated fill out different date columns due to a change within a dropdown column. If entry of the status dropdown is changed to pending, the current date should be displayed in the Date Pending column and - important - being locked for any changes. So that if…
-
Can I create a variable? Or two?
Hello, I'm working through some quotes for a project. In this project there area series of wall panels, in a series of locations. The material per sqft costs $X and the installation labor costs $Y per sqft. I have two cells in a hidden column that hold these numbers (should I have to edit it them later). Since the panels…
-
I am trying to create a Dashboard that will collect Vendor expirations ... 60 Days, 30 Days, Expired
I do not know the formula to create the answers. Can anyone help?
-
Collect and display nearest dates
I have a job tracker designed to track the art components of our jobs. We would like to have a column display the next nearest due date for that row. My trouble is we may have 1-10 due dates on a given row and there are non-date columns between each of the due date columns. I'm fairly sure I need to use a MIN(COLLECT( type…
-
Using ISBLANK with schedule health function
Hello, I'm using the below formula to calculate schedule health. The schedule delta is based off calculating the difference between columns Target Start Date, Target End Date and Actual Start Date, Actual End Date. =IF([Schedule Delta (%)]@row > 0.25, "Red", IF([Schedule Delta (%)]@row < 0.1, "Green", "Yellow")) It works…
-
Multiple IF/AND/OR/ Functions
Hi! I thought I had figured this out... but midway through making changes, realized that it's still not working quite as effectively has I thought. I'm currently using the below formula to change the Offer Phase parent row from "In Progress" to "Complete" if the following conditions are met: If the Offer phase in row 770…
-
Nesting a formula in an 'if' statement - conditional values
I have two reimbursement schemes for staff vs. managers for an expense, and am using a 'checkbox' to identify managers when submitting a claim. Managers will have a 'checked' checkbox in that column. I'm trying to use in a IF statement to behave in the following manner and can't get the syntax right. I'm striving for, in…
-
Summing up just the parents
want to do a summary field on a smartsheet that has a month for each parent and the children are transactions under each month they occur. each parent has a column (same column as the children) that has a total for the children. Without adding new columns to designate this is a parent, this is a child. Is there a formula…