I am using card view as a materials log and I have a question regarding the 'grouping' of cards. The problem: We have a pallet containing 4 boxes. The pallet is assigned to a lane in the sheet. I have…
Hi, I am trying to create a tracked schedule and was wondering if smartsheet had an option or setting that auto updated status based on the date entered and real time date. For example if a phase is d…
Hello all, I'm a fairly new (2 weeks) smartsheet user and I'm trying to write a formula that will count several columns based on specfic criteria. I want to count the number of Open projects (status) …
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEE…
Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column. There will be several matches per ID, e.g. Matt worked item …
Hi everyone, I need help on the following topic. I am trying to create a formula to show (measure) the running time in days between the column "done" and the column "creation date"? (see attached imag…
Hi to all and thanks for considering my request. We're somewhat new to SS, have looked at all templates without finding a product evaluation feedback form that would allow users to share issues, insig…
We are planning to implement a book publishing project in Smartsheet. At one point in this project, the pages of the book go back and forth between the writer, editor and compositor till it gets final…
Hello, we have been using Smartsheet for 4 years now for our project management and documentation. We are very satisfied with all the elements but have one issue. We have a lot of photo material for d…
Hi, when using a gantt the timeline normally expands between the columns "Start" and "Finish". Now, I have a third and fourth column which I would want to be on the same time line, but not as one long…