Hi, I have the following requirement: I have 2 sheets, each with the [Project Number] column as the ID. Let´s call the sheets [Intake Sheet] and [Picking List] The [Intake Sheet] holds, for example, a…
Hello, I work for a relatively small manufacturing company where our production managers meet every single morning, give their production numbers, headcount, etc to the manufacturing managers for them…
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'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range f…
No matter what I've tried, my Primary column seems to display with spaces before the first number, like it's more center justified than left justified. I have many columns so I'm always trying to redu…
I have an Auto-Number function running in one column and after number 1966, I added information in the next row, and it spit out the number 1997. I then deleted the information in the row and then add…
Good Afternoon, I've been racking my brain trying to get this function to work. I have a column set up to allow multiple selections of specific text with the column name "Processes." I want the cell t…
We are a millwork shop that uses Smartsheet for all of our projects. I want to see best practices on how to use Smartsheets to our advantage. As of right now we have a "sheet" that works as our produc…
Hello, I'm looking for a formula to calculate the End Date and Time (MM/DD/YYYY)( HH:MM AM/PM) based on the Start Date and Start Time entered on a form using the Task standard routing time.
The idea would be to be able to manage working days according to specific groups of employees. Some of our manufacturing technicians work during the day, some during the night and some in the week-end…