-
Multiple IF Statements for Various Scenarios
Hello! Based on multiple criteria, I'm building a formula to yield a completion %: I want the results to yield 0% if a specific field is marked "No" or another field is marked "No" or "N/A", populate 50% (.5) if one of two criteria are met, and populate 100% (1) if all criteria are met. I started building the formula…
-
If And Formula question
Hi, I am giving myself a headache trying to resolve the issues I am having with this formula. Currently this is set up to change the results in a dropdown Status column based on dates in other cells, its currently working well based on the above, as follows; =IFERROR(IF([Actual Submit Date]@row = "", "Pending", (IF([Actual…
-
Formula to generate series of dates
Does anyone know how to write a formula to have a series of dates generated based on entry of a starting date? In excel, you can enter starting date of 5/1/23, the next cell can can be +7 days so the date is auto generated to be 5/8/23, 5/15/23 etc. I can't figure out how to do this to save time for user since they have to…
-
Multiple If Statements not working?
Hello, I'm trying to setup a multiple IF statement but I'm encountering an error where the 2nd multiple if statement does not run. The first statement runs correctly but the subsequent statements always fail. The Formula: =IF(INDEX({Area 1 (AMER) QC sheet Range 4}, MATCH([SIM T: Customer Request]@row, {Area 1 (AMER) QC…
-
Is there a way to reference a summary field from one sheet in another sheet?
I have sheet that contains master data for customers. The master data customer sheet has a set number of support hours available for each customer. I have another sheet that is collecting support hour information for the customers. A summary field has been created for each customer that sums the support hours for that…
-
Formula to sum rows from one sheet based on a date range to a field on another sheet
Hi! As a brief summary, I have created a sheet for our laundry staff to keep track of how many items are being laundered on a daily basis. I have created a separate sheet for monthly totals of each item laundered. I am trying to create a formula that will sum the total number for each laundered item within each month. For…
-
Need Formula help!
I need a formula that will do the following: When the Date in WKU column has past place the latest NewPromiseDate from the AllPromiseDates column in the cell.
-
Check to see if a row is a Parent
I am trying to check if a row is a "parent". My definition of a parent is a row that has any children or a single row with no children. I have a column, called isParent, that I am adding to each row a 0 for not a parent (so a child row) and a 1 to the parent row I can get if the row has no children with this formula…
-
Count Parent rows only based on checkboxes.
Hello again! I am trying to create a better sheet. I have what I would call a "template". For each of the check boxes in the Report column, these correspond to a parent row. I would like to be able to have a formula that would count ONLY the parent rows. So, in my screenshot below as an example, the 3 checkboxes I have…
-
How to return most recent value when conditions met. Smartsheet Support is Stumped
Hello, I stumped Smartsheet Support with this formula question: I want to return the most recent approval status from another column based on common Project ID. I have four columns: Created Date - Project ID - Enter Status - Project Approval Status (Where the formula exists) All the columns are text except for Created…
