-
Adding information to templates
I am trying to work out the best way to do this. I have an evolving list of products (hundreds and hundreds) that can be ordered, and 29 people (only - this is set) who can order them for a Bulk Buy once a year. My current plan, was to create a Template, then have a sheet for each person. This way I can request them to…
-
Slow Response Time
Hi all, Is anyone else struggling with slow response times from Smartsheet. I have around 40 sheets that i work on, and 1 tab open. Even simple tasks like moving the mouse and clicking on a cell or an option is taking around 30 seconds to complete the action. I have tried this in empty sheets and still finding the issue so…
-
Autofill a value
Hi. I'm new at building formulas in Smartsheet. I have a numeric column that I want to autofill a 1 if no value is entered. Can someone help me with this?
-
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 )
-
RYGB Balls
I created a nested function to color designate the status of my projects tasks: =IF(Status="Not Started","Red", =IF(Status="In Progress","Yellow",=IF(Status="Complete", "Green",=IF(Status="N/A","Blue)))) The Red, Yellow, and Green balls work perfectly, however, when I select N/A from the drop down in the cell I get…
-
Auto number parent and child rows
I am trying to auto number the parent rows 1, 2, 3, etc and the child rows 1-1, 1-2, 2-1, 2-2, 2-3, 3-1 etc. Is there a way to do this as rows are added?
-
speed of sheet
I solved it never mind. Thanks if anyone was looking at this. I have a sheet that is moving very slowly, in fact the entire page doesn't seem to work when I have the sheet open. It is less than 30 columns and 100 rows, however it has many lookups and column references due to the nature of what I am trying to do. below is a…
-
Multiple linking
I'm looking to select a row based off of 2 criteria searched for in the row, and return a third value in the same row. I feel like this is possible with the existing functions but for the life of me I can't seem to figure it out. This wouldn't be difficult with array equations in excel but i'm not having any luck…
-
Web Forms
Hi Is it possible to have additional lines appear conditional on a specific answer (tickbox checked) I'd like 3 additional questions if the box is ticked. If not then I can add the questions, but will add 150 lines to my Web Form and makes it rather long.
-
Relationship between the "Status" column and other columns
I'm relatively new to Smartsheet, but it seems strange that the Status column appears not to have any relationship to other columns in the project sheet. But maybe it's possible to use a formula somehow to do that? Some specific questions: * If I change a task from Not Started to In Progress, can I set up Smartsheet to…
