Construction
Discussion List
-
Auto Functions w/ Update RequestsIn Using SmartsheetHello, 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 …
-
COUNTIFS/CONTAINS FUNCTIONIn Formulas and FunctionsHi 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…
-
Kanban View - printing or saving to PDFIn Using SmartsheetIn 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.
-
One off Saturdays in GanttIn Using SmartsheetHi 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…
-
Jira Connector only allowing one project to one sheetIn Premium Apps and IntegrationsHi, 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…
-
Dynamically update form dataIn Formulas and FunctionsLooking 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…
-
Index Match or Index Collect with multiple criteriaIn Formulas and FunctionsI'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 views 20 comments 0 points Most recent by Genevieve P Formulas and Functions
-
Is there a way to format numbers from decimal into fraction like excel does.In Using SmartsheetI 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?
-
Weather icon on calendar viewIn Using SmartsheetI 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. …
