-
Cell Linking Autofill or other means when sheet too big
I sent in a comment to Customer Success that the sheet is getting slow performance. The response was bust it up into multiple sheets. Well I like the idea, I'm not sure I like the solution - it make everything now manual unless someone can tell me a better way. The first four columns in my Master Sheet would need to be on…
-
Row Headers Not Aligned
Been using Smartsheet for about a year now in fully up to date Safari OSX 10.12.4 Suddenly yesterday the row headers do not align with their respective rows. Anyone else had this problem? Thanks in advance. David
-
One sheet, diffrent collaborators
Dear, We would like to use one sheet/workspace. This sheet with be used by different collaborators with different permissions: 1. On Site; 2. Engineering; 3. Project Management. I would like to make one column with the above mentioned. When i add a task to (for example) onsite. I only want them to see the task for On Site,…
-
Formula needed
Happy Thursday, all! I have a sheet with invoice dollar amounts in several cells.('Amount') Next to these cells, I have a checkbox column called 'Paid' that is checked on if the invoice was paid, checked off if the invoice was not paid. I need to total all invoice amount cells for invoices that are paid. Any tips on the…
-
Autofill - Formulas referencing above cell
Hi, I have one column creating a reference numbers for a hierarchy from three hidden columns similar to those using a format of 1.1.01. My Level 2 and 3 formulas are as follows =IF(COUNT(ANCESTORS()) = 0, <ABOVE CELL> + 1, <ABOVE CELL>) Number increases with each row, except where it is 2 or more layers in, in which case…
-
Cell Link from web form
Hi, I am trying to link the cell to other sheet, once the data is filled up from the web form. The problem I am facing is, whenever the form is submitted & the data is posted on my sheet, it is being posted below the cell which is linked to other sheet. I used the workout of providing the cell background color to white to…
-
Populating webforms with data from sheet
Hi friends, I will try and explain what I am trying to achieve: I have an issue tracking sheet with columns effectively divided into 3 sections: 1) Originator raises an issue on a webform, on clicking "submit" the sheet is populated. This works fine. 2) A webform is then created from the cells in the row corresponding to…
-
Totals by month
Hello, I'm trying to figure out how to get totals by specific month. There are 3 columns I'm trying to pull data from, a monetary column called "Unit Price," a dropdown list column called "Produced," with options that read "1. In Production" and "2. Produced," and a date column. Basically, I want to have a cell that shows…
-
Conditional Formatting For 11 Months From a Date
Hi Everyone, Thanks in advance for the help. Here is what I'm trying to accomplish. A service is sold on a specific date. We want a "timer" to start that will highlight the row yellow when it's 2 months from expiring. We want to highlight any row within the 10 month window from start date to be green & dates beyond 365…
-
Comparing Actual Duration to a Projected Duration with a +/- days
Three columns used are Duration(dependent), Projected Duration(I initially copy all of the durations over when setting the project) and +/- days(calculates the difference between Duration and Projected Duration) The trick here is you need to strip the "d" from the value to allow computations. =(VALUE(LEFT([Projected…