Construction

Discussion List

  • Auto Functions w/ Update Requests
    In Using Smartsheet
    Hello, I am trying to figure out if there is a way to 1) automatically add a new child row once someone has completed an update and 2) send out a "report" of updates (children rows) with the update requests so the person who the …
    Unanswered
    7 0
    Question 7 views 0 comments Started by Andrew Moore Using Smartsheet
  • COUNTIFS/CONTAINS FUNCTION
    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…
    5185 28
    5.2K views 28 comments Most recent by Paul Newcome Formulas and Functions
  • Kanban View - printing or saving to PDF
    In Using Smartsheet
    In the Kanban sheet, can this be saved to PDF in card view or printed in card view ? currently it shifts to list view when printing.
    328 6
    328 views 6 comments Most recent by Debra Roland Using Smartsheet
  • One off Saturdays in Gantt
    In Using Smartsheet
    Hi all, I work in construction and use the gantt chart heavily to manage scheduling subs. I have a unique situation for my project where I may have to schedule work on a Saturday. Is there any way to allow a single Saturday, instead of o…
    Answered - Pending Review
    8 3
    Answered - Pending Review 8 views 3 comments Most recent by Todd Winski Using Smartsheet
  • Jira Connector only allowing one project to one sheet
    In Premium Apps and Integrations
    Hi, We have recently implemented the Jira connector for Smartsheet and this is working well in each sheet where we have a one to one relationship with Jira Projects.  We have a single sheet which is collating all enhancement requests (usi…
    130 3
    130 views 3 comments Most recent by aclay Premium Apps and Integrations
  • Dynamically update form data
    In Formulas and Functions
    Looking for help... I'd like to update the fields on a form dynamically. Example:  Use the system-generated Creation Date to calculate a "Delivery Date" 2 weeks in the future and display it on the form.  I know I can do this on…
    78 4
    78 views 4 comments Most recent by Arvind Manoharan Formulas and Functions
  • Index Match or Index Collect with multiple criteria
    In Formulas and Functions
    I'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET. =INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row,…
    Answered - Pending Review
    434 20
    Answered - Pending Review 434 views 20 comments Most recent by Genevieve P Formulas and Functions
  • Is there a way to format numbers from decimal into fraction like excel does.
    In Using Smartsheet
    I am in construction and the need for fractional formatting is very important. I have seen other community questions from 2017 regarding this but has not been updated. Will there be an option for the formatting soon?
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • Weather icon on calendar view
    In Using Smartsheet
    I have been using smartsheet for several years, and I would love to see on calendar view a weather icon for, al least, one week. Just like Microsoft Calendar. My projects depends on weather, so its pretty important knowing the forecast. …
    58 2
    58 views 2 comments Most recent by scott.parr83911 Using Smartsheet