-
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.…
-
Automating Harvey Balls based on RAG status
Hi, Could somoen please help with the formula I need to use to automate completion of Harvey Balls based on RAG status of four phases? I am using RAG status balls (Green, Yellow, Red and Blue) to indicate status of each phase of the implementation. I have four implementation phases and basically want the Harvey Balls to Go…
-
Conditional Formatting
I have a question that someone may be able to help me with. If I have a column called Finish Date. On line 5 - I enter a date that my customer wants project to be finished On line 4 - I have a automatic date that is from a predecesor based on finish date so that it populates automatically depending on the tasks completed…
-
Looking for help with this
I am looking to build a sheet to compare rates from energy suppliers. there are a number of dependent factors which need to built in to the sheet which I dont know how to do. Can anyone help me please John
-
Trying to build a report, is it possible?
I'm trying to build a report from our company sales pipeline. Our pipeline has 7 sales stages. I'd like a report showing the percentage of our sales teams success progressing prospects from stage 3 or 4 to stage 5 (closed). At this point, I'm not sure how I need to approcae this report and build it. Would appreciate some…
-
Hiding columns based on yes/no condition
I am working on an implementation form, and would like certain columns to be hidden based on a selection in a previous column. For example: Column header: Is program a pilot? The options are yes and no. If the asnwer is yes, then the person must complete the following 6 columns. If the naswer is no, they need to be…
