-
Moved: tick check boxes in a column at once
This discussion has been moved.
-
Status Field - Conditional Formatting or If Function?
I am working on creating a tracking sheet for a longitudinal study, where clients need to be re-interviewed every six months until they are discharged from the program. I have a status field for each time point, and have used conditional formatting to change the color of the cell for each record, depending on the…
-
How do I count individual items in a drop down box
We have created a sign in form for our business. When a customer arrives they fill out the form. In the form is a dropdown of different areas of our business. We are trying to count on a sheet how many times an area in the dropdown has been visited.
-
Health symbols formula
Hi, I am a new user and I am trying to design a sheet for us. I am trying to write a formula to have the symbols return the following: If % complete = 100%, return gray; If target day is today and it is less than 100% complete, return Red; If the % complete is less than 75% and the target day is within 3 days of today,…
-
Update Date when Health Changes
Hi All, I've been tasked with finding a way to automate a column in a health-tracker for our PMO. Here is the ask: "When [Health]@row changes to Any Value (red/yellow/green/grey), update the [Date of Change]@row with the date the change occured" Simply, we need a way to automatically track what day the change in health…
-
IFERROR statement with an If(and... formula
I need help. I can get the if/and statement to work, BUT if the cell is blank it gives one of the options. =IFERROR(IF(AND([Bottom OP]1 >= [Spec - Low]1, [Bottom OP]1 <= [Spec - High]1)), "In Spec", "Out of Spec")), 0) without the iferror statement it will say "Out of Spec" where I want it to say nothing. Help appreciated!!
-
Trying to format the RYG balls according to Status and Due Date
I have formatted my RYG balls to change according to the status of the task; Not Started = Grey, In Progress = Yellow, Complete = Green, and so on. I want Red = Not completed, and also past due. This is what I have: =IF(Status@row = "Not Started", "Gray", IF(Status@row = "In Progress", "Yellow", IF(Status@row = "Complete",…
-
Formula to show if certain cells are blank change the status to red, yellow, or green
I have a sheet where we want to show if the columns successor 1, 2, and 3 are blank the status column should be red. If only successor 1 is filled out status should be yellow If successor 1 and 2 are filled out staus should also be yellow If all 3 successor columns are filled out the status should be green. Pretty much…
-
Lookups used to create a relationship
We're evaluating Smartsheet for project management. The business is commercial real estate. Projects involve matching a Client firm to a specific Property address, and that property also has an Owner. So if we have a Projects sheet, a Clients sheet, an Owners sheet, and a Properties sheet, we would need to tie these…
-
Proper Syntax for IF and VLOOKUP
I am trying to create a formula that will run VLOOKUP if a cell is blank This doesn't error but it leaves the formula field blank =IF((USERR3 <> ""), (IF((VLOOKUP(SDR3, {SFDCUsers Range 1}, 2, false)) = 0, "No", "")))