functionality

Discussion List

  • Attachments in Forms
    In Using Smartsheet
    Hi Everyone, We have a form which will be filled by the customers. There is a attachment field added to the form. Now, we want two types of attachments to be done - 1. Invoice copy & 2. Images of the issue. Invoice copy should be man…
    Accepted
    17 1
    Accepted Answer 17 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Can an intake form populate more than just a new horizontal row in a sheet?
    In Using Smartsheet
    I have timeline templates built out in a cascading fashion (with parent and children relationships) using "workday" formulas and a holiday list. I'd like to start the timeline off with an intake form. The customer would enter t…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Can I populate Smartsheet rows from a SQL Database read?
    In API & Developers
    I have data on Snowflake data warehouse and also on a SQL server table. Does Smartsheet support connection to Snowflake or SQL database to read data and populate rows on a Smartsheet?
    Answered - Pending Review
    1206 6
    Answered - Pending Review 1.2K views 6 comments Most recent by Richard Rymill SBP API & Developers
  • Trying to combine 2 AND functions with an OR
    In Formulas and Functions
    Hi There! I am new to SmartSheets and am working on a way to automate a process using the OR with AND's and running into trouble. Basically, I am trying to check a box in a column if any of the following is true. If the Model type is 1 AND…
    Accepted
    298 18
    Accepted Answer 298 views 18 comments Most recent by Paul Newcome Formulas and Functions
  • Add Comment Section to a form
    In Using Smartsheet
    Hello, Is there a way to add the comments section to a form? Or a formula to move / copy text from a comments column into the comments section? Thanks! Matt L.
    Accepted
    679 5
    Accepted Answer 679 views 5 comments Most recent by Waleed Using Smartsheet
  • Full sheet daily backup
    In Using Smartsheet
    Hello, There are several asking has a complete sheet backup feature been implemented since this post? The post is a 2018. We are looking for a solution where the sheet itself is backed up and can be retrieved with all attachments, comment…
    Answered - Pending Review
    4 1
    Answered - Pending Review 4 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • List of date formula I have used repeatedly
    In Best Practice
    Doing this so I have an ongoing list of functioning optimized formulas , keeping it in the community in case it helps someone else. Please feel free to comment with your own, but I'm keeping the most basic of the formulas out of this. Bel…
    230 15
    230 views 15 comments Most recent by L_123 Best Practice
  • Parents Misrepresenting Start & Finish Dates of Children
    In Formulas and Functions
    I have the Parent Rollup Functionality turned on as it is essential for my project to handle to dependencies. The problem I'm trying to overcome is that the Parent displays Target Start (TS) and Target Finish (TF) dates when not all childr…
    Answered - Pending Review
    11 6
    Answered - Pending Review 11 views 6 comments Most recent by Chris Albig Formulas and Functions
  • End of Month Function
    In Formulas and Functions
    Good afternoon all, I'm trying to figure out how to apply the =EOMONTH(A1,0) from excel into a smartsheet. Any guidance on this would be most appreciated! Thanks!
    Accepted
    1208 11
    Accepted Answer 1.2K views 11 comments Most recent by Paul Newcome Formulas and Functions
  • Count number of days in date range that fall in current week
    In Formulas and Functions
    Hi everyone, I have a number of project plans in Smartsheet and am trying to get a summary of how many task hours each person has assigned for the current week. The plans currently capture task Start Date, End Date, and number of hours req…
    Accepted
    13 2
    Accepted Answer 13 views 2 comments Most recent by Eric James Formulas and Functions