-
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…
-
Basic A/P and A/R payment tracker
We're a property management company with a construction arm. Our construction is basic and requires us simply to track Owner/Address/Date of approval/Job number (which we create)/Contractor's Bid/Change orders/Payments to Contractor/Balance to contractor/Our Bid/Change Orders/Payments to us/Balance due us/A/R for cash paid…
-
Check a box in the phase row, if all the tasks are complete
This should be easier but I'm struggling with it. If all the tasks are complete, indicated by check boxes, I want to automatically mark the phase complete. So, the box in black below should automatically check when the other boxes below it are all checked.
-
Can I use an if statement to return a numeric value based on red yellow green symbols
I am trying to create a scorecard and would like to return a numeric value based on symbols (green = 5, yellow = 3, red = 0). Is that possible? Formula help would be amazing!
