Discussion List

  • 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?
    1574 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
  • IF condition is true, copy a value into another column
    In Formulas and Functions
    I have a sheet where multiple people have to approve an item before it is 'approved'. I am needing to copy a cell from the Cost column into the pending, approved, or rejected column based on the current status. So if the P/R/A column equa…
    29 1
    Answered ✓ 29 views 1 comment Most recent by Intern98 Formulas and Functions
  • Expand/Collapse rows
    In Using Smartsheet
    Expand / Collapse all is not an option on my primary nor any of my parent rows.  Why?
    3127 6
    3.1K views 6 comments Most recent by Abeiis Using Smartsheet
  • Off-line Client / Integration or Workflow Recommendations for Smartsheet
    In Using Smartsheet
    My very short question is: After researching that Smartsheet does not offer a desktop client or offline mode, are there any software solutions on the market that offer an integration from Smartsheet to a client based application; or perha…
    Answered - Pending Review
    34 2
    Answered - Pending Review 34 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • JIRA Sync To Smartsheets Not Syncing
    In Using Smartsheet
    The Problem: JIRA is actually not auto syncing like it should to pull in tickets automatically into smartsheets Notice: The workflow is set correctly to sync JIRA fields to smartsheets The Problem: We have to go into this workflow manually…
    Answered - Pending Review
    39 1
    Answered - Pending Review 39 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Pre-populate a form
    In Using Smartsheet
    I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change c…
    Answered - Pending Review
    8078 64
    Answered - Pending Review 8.1K views 64 comments Most recent by kadie Using Smartsheet
  • Linking checkboxes across 2 sheets
    In Formulas and Functions
    I've got 2 spreadsheets for tracking job progress. One is an end of day report filled out by field personnel. The other is a collection of all the information about various jobs gathered from the end of day reports and manually entered dat…
    Answered - Pending Review
    841 13
    Answered - Pending Review 841 views 13 comments Most recent by Paul Newcome Formulas and Functions
  • Formula to calculate difference between projected and actual dates
    In Formulas and Functions
    I have a project schedule where I have projected and actual dates for most of the deliverables, and I need to track the faster project path. Is there a formula that can automatically select the earlier date between the projected submit dat…
    Answered - Pending Review
    70 1
    Answered - Pending Review 70 views 1 comment Most recent by Jeff Reisman Formulas and Functions