-
conditional formatting
Hello!! Hopefully someone can help.... I would like to run a conditional formatting where I enter a number in column 1 and that will produce specific text in column 2 I can only see option of changing the cell colour and not having the condition produce a line of text Thanks Celine :o )
-
Links not updating
Hi All, I would appreciate it if someone can help me out. I double checked that my links are linking to the correct areas between two sheets. But it is not updating the sheet it links to. Please advise and see screenshot. Thanks, Y
-
Auto-fill form/cells when a certain item is selected from a drop-down
I was wondering if it is possible to auto-fill cells based on an item that is selected from a drop-down. I am trying to create a form for our subcontractors to upload submittals and I wanted them to be able to select from a drop down list what they are submitting. I.E. Product Data for Paint, or Samples for flooring. Once…
-
Generic "Forms" embedded in a sheet?
HI, I am pretty new to Smartsheet so, please forgive me if the solution to this question is obvious to most. :) Our company is developing some project management sheets to help us in our transition to paperless. We have put together a template that we feel pretty satisfied with to get going and as we start each project, we…
-
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
-
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…
