Discussion List

  • Dropdowns in a dashboard, is it possible?
    In Using Smartsheet
    I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics. *The drop downs show their total …
    1618 13
    1.6K views 13 comments Most recent by Gaurav K Using Smartsheet
  • formulating dates excluding weekends
    In Formulas and Functions
    I have 3 columns with different dates. My goal is to enter 1 date, and have the other 2 dates formulated based off the 1st date. I created a formula to satisfy this need, but I am ending up with some dates falling on weekends, which I cann…
    25 2
    25 views 2 comments Most recent by Maz Uddin Formulas and Functions
  • Formula under Duration in a Gant chart
    In Formulas and Functions
    Hi there, I'm new to smartsheet I want to switch from MS Project to smartsheet to set up the planning schedule. I know we can assign multiple of people to a task but at the planning/biding level, I just want to juggle with the number of re…
    300 3
    300 views 3 comments Most recent by Tom L Formulas and Functions
    In Formulas and Functions
    Hi All,  I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula: =COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, &qu…
    10745 45
    10.7K views 45 comments Most recent by Genevieve P. Formulas and Functions
  • Way to have multiple people claim an item
    In Formulas and Functions
    Hello. I have a sheet that shows available material that our workers can "claim". I have a formula that populates the Available Quantity after a number is entered into the Quantity Claimed column. I am looking for a way to have m…
    Answered - Pending Review
    33 1
    Answered - Pending Review 33 views 1 comment Most recent by Kevin Smith Formulas and Functions
  • Calculating cumulative values and reducing the total sum each day
    In Formulas and Functions
    Hi, I have a Safety Violation Sheet that uses Form Entry to record violations and assign a measured Probation Period in days. If there are multiple entries for an individual, the probation days should accumulate, at the same time the value…
    Answered - Pending Review
    368 9
    Answered - Pending Review 368 views 9 comments Most recent by Paul H Formulas and Functions
  • Formula for Hours Scheduled by Month
    In Formulas and Functions
    We're trying to determine how many hours we have scheduled in a month for a particular project based on the start and end date of the project. I can't quite figure out how to set the MAX/MIN without the EOM function. Can someone please hel…
    Answered - Pending Review
    44 12
    Answered - Pending Review 44 views 12 comments Most recent by Paul Newcome Formulas and Functions
  • Quickbooks & Smartsheet
    In API & Developers
    So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.  It has many application & the proof of concept exists and we use it.  We use it for an approval process (for in…
    5921 33
    5.9K views 33 comments Most recent by JeremiahHorstick API & Developers
  • Filter to show only dates from this week???
    In Formulas and Functions
    I'm making a project schedule for our construction company. I would like to be able to have a filter that only shows "Start Date" that is equal to this week or this month. Is that possible?
    1568 22
    1.6K views 22 comments Most recent by Suzanne Raphael Formulas and Functions
  • Multiple nesting help!
    In Formulas and Functions
    So I have 6 survey questions with response options of "below expectations, meets expectations, and exceeds expectations." I need it to tell me how many below expectations for question 1 are in each region and so forth for each re…
    Answered - Pending Review
    27 3
    Answered - Pending Review 27 views 3 comments Most recent by Jon Mark H Formulas and Functions