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 alwa…
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…
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 it…
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.
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…
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…
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 - Pro…
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/Chan…
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 automatica…
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!