-
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…
-
Conditional Funding
Would there be a way for me to add my second and third columns based upon the conditional formatting of the rows? the conditional funding only depends upon one variable.
-
Conditional Formatting or Formula?
s it possible to create a formula or a conditional formatting rule that would automatically highlight any child rows as they are created and/or based on a specific term or text in a column of the parent row?
-
Web form phone contact filling by customer missing number can it set formatting?
Web form phone contact filling by customer missing number can it set formatting? Due to our client typing through the form by themselves some time we can't control what they type. At this stage, for my case I just wonder is there a way to set the format condition to make the fill in data from this example Phone…
-
Turn hours (hh:mm) to numeric value (00.00)
Is there a formula to make a column with duration values like 1:30, 2:45, 3:15, etc etc (only ending in either :00, :15, :30, and :45) to 1.5, 2.75, 3.25 hours (again, only ending in .00, .25, .50, and .75, respectively)??? I am VERY new to SmartSheet so, if you could actually explain how to do stuff that would be awesome.…