-
Burn down
Hello, i would like to assign cost rates to different people and to auto calculate the burn rate for my projects. this information cannot be shared with the people that the prject are shared with. Is there a way to do this? thanks, kate
-
conditional on children function
I am using this =COUNTIF(CHILDREN(), "Y") + " Bidding" which returns the number of contractors bidding. I would like to change the font color depending on a range of values that the "count" returns. I can get the zero value easy enough but I wiuld rather not enter a conditional statement for every possible numerical value…
-
Sheet Size
I have sheets that vary in size but most lean to the larger size due to the amount of formulas in the sheet. I am looking to see if on average people are choosing to have more sheets and less size or less sheets and fill the sheets to the top. I have done alot of work to all of my sheets and some have had to be divided. If…
-
Automatically copying a row to another sheet depending on if a certain cell matches the sheet.
I was wondering if there was any way of automatically moving rows of information depending on information found in a specific column. For example. I have one sheet that lists tasks that have been done by employees and the job number that they were working on (i.e. 165-07). I also have other sheets that provide the…
-
automated movement between parent grouping for roll up sheet?
Is it possible for a row to "automatically" relocate itself from (1) parent child grouping to the NEXT parent child grouping? Right now, I have to manually move them. I have a roll up sheet for our design clients. The roll up sheet is organized by stage of process and all information is auto filled in from the actual…
-
I need to build a formula that looks at some cells in a column but not all of them.
Hi everyone, I'm trying build a formula that looks at a column of check boxes, and if certain boxes are checked off, it will give me a "green light". Here is the formula that currently works: =IF(COUNTIF(Completed13:Completed26, 0) > 0.5, "Red", "Green") It compiles all the check boxes in my column from row 13 to 26,…
-
Conditional Cell Linking
Hello, I could use some help on something I'm trying to do in SmartSheet. Scope of Project: I have a master inbound "Lead Tracker" sheet that I use to keep track of referrals sent in from various business partners. I would like for these business partners to have access to their own "Lead Tracker" as well which would…
-
Default Symbol Labels
I am using standard symbols in a drop down box. They have the default lables 'Yes, No, Hold'. Is there a way to change these default labels within this sheet?
-
Can I give the RYGB Balls column "Status" a default colour when a new row is added to the sheet?
I think my question speaks for itself. The RYGB balls type has 4 coloured balls. Which I'm using as follows. Blue = "New task" Green = "Active task" Red = "Finished task" Yellow = I'm not using this one. So what I want is for a new row in the sheet, is for this column to automatically turn "Blue" to indicate a new task. It…
-
Merging inventory
I have an inventory I do each month and have a fairly simple question but not sure what is the best way to complete this task. I have 3 columns. ItemNumber, ItemName, and TotalQTY. The first sheet is what I actually have on hand in the warehouse the second sheet is what our system says we should have. So far very simple.…