-
Method of linking data from source sheet with an increasing number of rows
The function I am looking for would allow for data to be pulled from a source sheet which is increasing in size and be kept in sync for maintaining accurate information. To help explain, at the moment I can link an entire column of 'Engine numbers' with number n (approx 300) rows and the corresponding data with no problem.…
-
Predicting a bad situation
I have projects with 3 milestones, call them A, B, C C is dependent on B which is dependent on A. C is a critical completion date. If either A or B is late, C is automatically late and that is very bad. If A or B is late by X number of days, C automatically is now going to be late by that same number of days. I'm looking…
-
Inventory checklist
I have to create an inventory checklit based on an Excel document I will have 2 main sheets: Inventory & Picks Inventory will have a list of all the SKU/units that we have per product. Picks will need to offer me the option to select one item from the Inventory sheet and once I pick it, it has to tell me if we have enough…
-
Conditional Formatting
Hello, Is it possible to apply conditional formatting only in specified rows or does it only apply to the whole sheet? My example is as follows: I am currently tracking production on 20 units. For the first 5 units I do not care if the duration of a planned task exceeds its target. However for the next 15 units, I do want…
-
Moving rows from one sheet to another
We use Smartsheet for our production schedule. The schedule consists of 9 sheets that are all in a workgroup. Is it possible to setup a rule that would allow a row from one sheet to be moved to another sheet using the checkbox feature? Thanks, Jim
-
Issues assigning tasks to non-licensed users
We are at the beginning of our Smartsheet implementation and are having issues with assigning tasks to project team members that do not have Smartsheet licenses. The error we receive is: The user never receives the email referenced in the error message so they are unable to proceed. Have any of you run into this issue? If…
-
excel doesn't recognize text/number column from smartsheet
I've linked an Excel worksheet to a Smartsheet report it works fine but one column that has a numbers and text (p.i. 4551A) is imported blank (no data). When is a regular number imports it just fine. Does anybody have any idea what could be the problem? Thanks, Herb
-
Moving Massive Qty of Rows
Good Afternoon, I'm currently dealing with a minor issue with SS while moving rows. Once a month, we move a single months worth of data from our main Completed sheet to an Archive sheet I have created, to keep record of previous rows that have been marked complete past 3 months. I do this to keep the loading time down in…
-
Formula Help (does not contain)
Columns "Risk" "Start Date" "Part Status" I want "Risk" to FLAG, if "start date" is TODAY or > and "Part Status" is NOT "shipped" or "in progress" I have the formula below for if start date is today or > =IF(ISDATE([Start Date]4), IF(AND(TODAY() > [Start Date]4), 1)) How can I combine AND if "Part Status" is NOT "shipped"…
-
tracking Project by the hour
I have started a small project shedule for a job that will take around 72 hours to complete total but with multiple subs having to start and finish at certain times to hit that deadline. how do i change the calendar on the Gant to #1) just show me the 3 day assigned to the task #2) break each day down to a 24 hour time…