Conditional Formatting

Discussion List

  • Filling Columns based on a Selection From Dropdown
    In Formulas and Functions
    I am working on a formula and cannot get it to return correctly, I need to be able to select one of two options in a dropdown. I was using a vlookup and kept getting the N/A for all of them even if the condition was met. I think I missed a…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Malaina Hudson Formulas and Functions
  • Formulas & Filter Assistance for a To Do List
    In Formulas and Functions
    Hi, I have tried a few searches and haven't quite found what I need to perform the function within my smartsheet. Hoping some of the Formula wizards can help me out. I am using Smartsheet to manage my to do list. The filters are great bu…
    Answered - Pending Review
    14 3
    Answered - Pending Review 14 views 3 comments Most recent by Bassam.M Khalil Formulas and Functions
  • Flagging a Date and Time Overlap
    In Formulas and Functions
    Hello,   I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as…
    417 24
    417 views 24 comments Most recent by Paul Newcome Formulas and Functions
  • CountIf for check boxes
    In Formulas and Functions
    Good afternoon,    Can you do a Countif formula for a column that has checkboxes.....so that you can count how many rows have the check box?   Thanks    
    5961 11
    6K views 11 comments Most recent by Genevieve P Formulas and Functions
  • Countif todays date and by someone
    In Formulas and Functions
    I want to count how many times someone completes a form today I was able to count if yesterdays date with: =COUNTIFS({Store}, $Name6, {Created}, TODAY() - 1) but can't find a way to calculate todays entries
    Accepted
    23 7
    Accepted Answer 23 views 7 comments Most recent by Mark Cronk Formulas and Functions
  • CheckBox Formula
    In Formulas and Functions
    Greetings! So, I have a "Done" column and a "Status" column. Status column values = Not Started , In Progress, Complete Done value = Checkbox The Goal: When I check the "Done", I would like to have the Stat…
    Answered - Pending Review
    24 2
    Answered - Pending Review 24 views 2 comments Most recent by Melita Clark Formulas and Functions
  • Is it possible to send specific columns of two spreadsheets to a third one?
    In Using Smartsheet
    Hi everyone I have two spreadsheets and I want to take some columns of sheet 1 and others from sheet 2 and put them in a third one and that every time an update is made in sheet 1 or 2, it also apply on the third one. Including new rows, d…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • SUM cells with formulas not working
    In Formulas and Functions
    Hello, I have a sheet with a column of cells with formulas in them. These formulas produce numbers. Then I have a second sheet, where I have a formula in a cell that references the first sheet's column with numbers. This formula in the sec…
    437 12
    437 views 12 comments Most recent by Sunil Kadikar Formulas and Functions
  • Formula Quesiton
    In Using Smartsheet
    I have 2 columns - one Engagement and one Desired Engagement - If the two columns are not equal, I want the cell color to be yellow as an indicator. If the two columns are equal then, do nothing. How can write that formula in smartsheets (…
    Accepted
    22 3
    Accepted Answer 22 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Completed Tasks removed from calendar
    In Using Smartsheet
    Is there a way to remove completed tasks from the calendar without removing them from the sheet? I have a done column that checks off and greys out the row but the information still shows up on the calendar is there a way for it not to sho…
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by Sara Moore Using Smartsheet