Construction

 

Discussion List

  • 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…
    Unresolved
    22 2
    Question 22 views 2 comments Most recent by Shawn Leahy Formulas and Functions
  • Cell Linking from a Form
    In Using Smartsheet
    Hello I am trying to do cell linking from when the information is entered in from a form rather than directly onto the sheet itself.  When I do this it adds the information onto the sheet however it moves the cells I am trying to link down…
    94 5
    94 views 5 comments Most recent by Sharon Isaac 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
    508 10
    Answered - Pending Review 508 views 10 comments Most recent by Paul Newcome Formulas and Functions
  • Report on all sheets I am part of as Assigned To
    In Using Smartsheet
    Many of our team members will be allocated to many different sheets. 1. Is there a feature how to make a report showing all sheets I am assigned to?, and as a continuation a report showing specific tasks in those projects, for example Gat…
    256 5
    256 views 5 comments Most recent by Jose Maria Martinez Using Smartsheet
  • Automatic Children Indenting
    In Using Smartsheet
    Hello,   Is it possible to set up a formula for information (if it is the exact same as the parent/child row above) that you have underneath a child/parent row to automatically attach itself inside the Parent/Child Hierarchy? I would rat…
    1034 17
    1K views 17 comments Most recent by Caitlin Smith Using Smartsheet
  • RTF in Dashboard Widget
    In Using Smartsheet
    I downloaded an example dashboard which tracked multiple projects.  Looked good and decided to build my dashboard to match example.  Example dashboard has a Rich Text Widget which has multiple formats within.  However when I try to use the…
    362 10
    362 views 10 comments Most recent by pjh Using Smartsheet
  • Show ONLY Tasks in a Date Range
    In Formulas and Functions
    Is there any formula and/or filter that will enable me to show only the tasks that are scheduled to happen during a particular 3 week time frame, much like a 3 week lookahead. I want to show tasks that, during the time frame, have the foll…
    Answered - Pending Review
    1 2
    Answered - Pending Review 1 view 2 comments Most recent by Wesley Cross Formulas and Functions
  • Trying to delete a large number of rows trough API
    In API & Developers
    Hi I am using the Node JS SDK to delete the content from a sheet. It works fine but for a lot of rows it fails (I have tested with a minimun of 1000). I get an error that says that the request is to large for the server. I understand what…
    172 5
    172 views 5 comments Most recent by Ian Macintosh API & Developers