-
How can my rows autofill the formulas when a new entry is generated through a form?
I have worked out several formulas in my sheet. Now I want them to be autofilled whenever a new entry is filled through a form. I don't want to drag them manually everytime there is an entry because I want automated workflow to follow. Also, if I drag a couple of cells prior to the forms being filled, then what happens is…
-
Legal projects/task management sheet
Hi, I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce. To track the work, I have created one sheet for the legal team to use, covering all main "legal work" categories and then broken down to sub categories, tasks and then sub…
-
Register and calendar integration
Hi, I need assistance in creating a calendar which will show the number of locations where material deliveries will happen (5 locations) over 24 hours - 365 days a year. The idea is to then create a dashboard with the form and calendar and share it with the senior members of my team so that they can book delivery slots by…
-
Indent from a form
Is there a way to have a row come in automatically at the same indent level as the row above it? My top row is a parent row with calculations based on all of its children. The children rows are all web form generated and they do not come in indented so I have to manually indent each row as it hits the sheet.
-
When saving as a Template do the shared filters carry into a new sheet created from the template?
I have tried this several times but the filters I create before saving as a template do not appear in the derived sheet. The check box above leads me to believe the filters should be in the template.
-
Form flowing into bottom as child row
Hello I have a parent row on a sheet and I would like new entries that flow into that sheet through a form to be automatically indented so it's a part as a child row to the parent row from the beginning. Also, there is a formula that isn't being pulled down to the new row right away. How do I get the formula to fill in?…
-
Is it possible to generate a client sign off for an inspection in the field using a tablet?
Hi, I work in construction and after our project managers inspect a project in the field I'd like them to have the ability to generate an inspection form for the property owner to sign on site using a tablet. Right now they are using a sheet showing all measures that were inspected where they write down the quantity of…
-
Ideas for how to automate distributing Meeting Agendas and Minutes ?
Hi, I am trying to create a meeting minutes template which both facilitates taking minutes against an agenda and also automates distribution of minutes to 'Attendees' when ready. I am using multiple rows to list Agenda topics (under a parent Meeting Title line) and then logging the minutes for each topic in a neighboring…
-
Is it possible to change the layout/ style of the Gantt chart?
Hello, to present an overwiev of the projects I´m managing with Smartsheet I need a more "presentable" version of the Gantt chart. Is there any chance in Smartsheet to make the Gantt look different, for example to make some tasks thicker than others or to change the entire form of the chart? As far as I know it´s not…
-
How to pass Row Number to MATCH function?
Hello all! I am trying to work with the MATCH and VLOOKUP functions, to create alerts to let people know it's time to begin their assigned work. For example, if Task 2 is a predecessor of Task 3 (that is, if [Predecessors]3 = 2), I want to do a MATCH and VLOOKUP on Row 2 that shows [Assigned To]3. That way, when [Status]2…