Conditional Formatting

Discussion List

  • #UNPARSEABLE using COUNTIF for text objects
    In Formulas and Functions
    I have a Form which allows the recipient to answer a question via a drop down list: Example: Where would you like to go for vacation? List includes: U.S., Europe, Asia, Australia It's a pick many list so users can select any number of answ…
    Accepted
    32 5
    Accepted Answer 32 views 5 comments Most recent by Mark Cronk Formulas and Functions
  • Converting a formula to a "column formula"
    In Formulas and Functions
    I am trying to convert this formula into a column formula. It takes selected cells from a row to populate the overall "Status" column. If tasks are "Not Started", the overall status will be "Not Started". The…
    Accepted
    22 2
    Accepted Answer 22 views 2 comments Most recent by Sarah.S Formulas and Functions
  • 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
    21 3
    Answered - Pending Review 21 views 3 comments Most recent by Aimee Peyton-Greene 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
    23 3
    Answered - Pending Review 23 views 3 comments Most recent by Bassam 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…
    929 24
    929 views 24 comments Most recent by Paul Newcome 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
    127 7
    Accepted Answer 127 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
    61 2
    Answered - Pending Review 61 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
    11 1
    Answered - Pending Review 11 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…
    682 12
    682 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
    21 3
    Accepted Answer 21 views 3 comments Most recent by Andrée Starå Using Smartsheet