Conditional Formatting

Discussion List

  • Is there a way to create a search box?
    In Formulas and Functions
    We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and th…
    501 11
    501 views 11 comments Most recent by Reni Viessmann Formulas and Functions
  • 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…
    320 11
    320 views 11 comments Most recent by Kyle Walker Formulas and Functions
  • Conditional Formatting - One rule on multiple columns
    In Using Smartsheet
    Hello, To make our Smartsheets more legible when used for input requests, we use conditional formatting.  For example, if we have a table used for percentage-splits with 12 columns and 100 rows we generally pre-populate these inputs wher…
    729 views 8 comments Most recent by Genevieve P Using Smartsheet
  • Count how many jobs start in a month
    In Formulas and Functions
    I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="…
    107 3
    107 views 3 comments Most recent by Genevieve P Formulas and Functions
  • Using Smartsheet Forms
    In Using Smartsheet
    I have this schedule above (took out the names/privacy) for weekly schedules with my team. Normally there is a time frame in each cell for thee week like 9:00-5:00. Each week pulls down, I just have week 3 as an example. And this form: …
    Accepted
    16 2
    Accepted Answer 16 views 2 comments Most recent by Addison Spencer Using Smartsheet
  • Wrike/smartsheet Integration?
    In Premium Apps and Integrations
    One of our departments made a decision to get Wrike last year. They've told me it can integrate with smartsheet- but I haven't found anything that explicitly gives how-to kind of guidance or is it just an API kind of thing where we have t…
    Accepted
    7 3
    Accepted Answer 7 views 3 comments Most recent by Jillian Amyot Premium Apps and Integrations
  • Dynamic dates
    In Using Smartsheet
    Very new to this program so hopefully this is not a stupid question... I need to set a sheet up where there are fixed times within a 4 week cycle for certain steps to occur. For instance we can only order a certain pack on Friday of week …
    43 views 2 comments Most recent by Jody Odom Using Smartsheet
  • How to create metric from timestamp in sheet
    In Formulas and Functions
    I am trying to create a metric in my dashboard that shows the average time of day that each contact submitted their request. The specific date is not relevant. Please help Thanks!
    Accepted
    27 4
    Accepted Answer 27 views 4 comments Most recent by Noah Webster Formulas and Functions
  • Limiting Characters in a Cell/Date Validation
    In Using Smartsheet
    I want to limit the number of characters that a requester can enter into a cell via a form. The use case is that the user is entering a new request for consideration into an Intake Form. In assigning a name to their project request, we wan…
    73 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Forms that need to incorporate multiple line entries
    In Formulas and Functions
    We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is fi…
    235 19
    235 views 19 comments Most recent by Andrée Starå Formulas and Functions