-
Is it possible to use a multi-select cell as the criterion for a COUNTIF formula?
I have one sheet with training items for different positions (All, BD, CTL, etc.) As these items are trained they are marked as "Complete" from a list of "Not Started" "In Progress" "Complete". I have a separate sheet that I would like to use to track training progress for the employee. It gets complicated because anβ¦
-
Locking Values in Row
IΒ have a column on Sheet 1Β that has a formula that references a value on Sheet 2. If the value on Sheet 2 changes, obviously the cell in Sheet 1 updates automatically. I have another cell in Sheet 1 that is a dropdown. One value in the dropdown is "Completed". The values in Sheet 2 may change once a year, as we adjustβ¦
-
I am wanting to use RGB dots for elapsed time
I am wanting to see if there is a way to utilize the RGB dots to represent elapsed time when a status drop down is changed. Would like GREEN if less than 24 hrs Yellow if over 24 hours but less than 48hrs Red if over 48 hours. Is this possible in SmartSheet?
-
Add Not Blank to formula and display word
I need to add another element to the following formula. The below formula works beautifully, however now I need to look at another column to see if there is a date displayed and if so (not blank) then display the word "Termed". Current formula: =IF(AND([Trailing 24M ratio]@row < 1, [Trailing 12M ratio]@row >= 0.9), "Yellowβ¦
-
How can you delete the yellow RYG status dot from the drop-down list?
My team is working on a status sheet and is using the drop-down RYG gumballs/dots for status. However, we are only working with Red, Green, and Blue. We would like to remove the yellow dot option so people are not choosing a status option we are not using. Is that possible? has anyone ever been able to do that? Thanks!
-
Using Logic to Autofill Other Fields in a Form
I have a form where a user would select options from a drop down. Ideally, like to setup logic so that when they select option D, there is another form field (let's just call it Field 2) that is then hidden and has its value set. There are other times when if they were to chose Option C, they would need to decide whatβ¦
-
Access Hidden Confidential Data
I need to "hide" employee salary data. I would like to have a separate grid spreadsheet with the data in it, I have locked the cells. When I link to the cells from another sheet, the actual amount shows up. How can I hide this from the sheet I link it from. To add more, this is to figure margin based on bill rate of aβ¦
-
Formula to show Health of opportunity based on 2 status columns and due date
I'm trying to write a formula that will change the Health column to B, G, Y, R depending on status of 2 columns and the due date. When the OPP STATUS is Closed/Won, the SETUP STATUS and the START DATE will determine the color indicating the health of the opportunity. I am grateful for all of the help I have received fromβ¦
-
Cross referencing Sheet-formulas
Hi I want to look up the requestor name ,Department rep,Department Rep(second if applicable) for each Tracking ID from another sheet which contains the names of these department reps. If a department name is entered the corresponding column should return the name of the rep from the other sheet. Which is the best functionβ¦
-
How to List Parents By Common Child
I am working on a project book of work and currently have a list of resources listed by project: Project 1: Rich John Angela Carly Ted Project 2: Tim Jeff Rich Ted Project 3: Sam Tim Ted I am looking to create another sheet that will automatically pull from this first sheet and show the resource and the projects that theyβ¦