-
Autofill is working on some formulae in a row and not others
We have been using SmartSheet for about 3 years and have recently developed an approach for our project managers using SmartSheet. We are about to roll it out to our staff but have found an intermittent behaviour that is most troubling. Sometimes, just sometimes, when we insert a new row or add a new row at the end of the…
-
Historical Report Status
I am looking to increase my efficiency when creating statistical reports. Each week, we run a report to see how our projects are tracking (red, yellow, green traffic lights) but I what I want to do is keep each weeks statistics so that I can create a historical report of these figures. At the moment, each week I need to…
-
Assigning contact to multiple tasks
Is it possible to assign a contact to more than one task at the same time? I have a sheet with 65 rows - there are contacts with multple tasks so trying to avoid having to pick from the list on each single task. Thanks in advance for any help offered.
-
PM's with multiple types of projects - approach?
team of 5 people, with four project types. - think new, inline, market research, and outreach. would you have a sheet template for each project type, and make a new sheet for each project, or one master sheet for each personwith a "project type" drop down or some other way? The projects have aboout 25% overalpping data and…
-
Sorting heirarchy numbers (1.1, 1.1.1, 1.2) in reports
Hi everyone, I am using reports to merge 20 to 30 sheets and sorting them on multiple and different heirarchy columns (containing numbers such as 1.1, 1.1.1, 1.2). This doesn't really work out of the box because the report sort is apparently just a standard natural sort and doesn't recognize this notation. I wasn't able to…
-
Adding carriage return/line feed to calculated text
I'm pretty sure I know the answer (no) but ... can I format text with a carriage return in a formula? For example ="Line1" + \n + "Line 2" where \n is whatever I need to add to get this result: Line 1 Line 2 This article did not help.…
-
Using reports in Sights Metric Widget
Hi, Is there way we can use Reports within a the Metric Widget in Sights? I have a set up where I am trying to display "Counselor of the Day" in this widget, but my only option is to use the sheet as a source. When I do this, the link to the source cell is static and It only points to the cell that was initially selected.…
-
Feature Request: Toggle on/off a Report Builder search parameter
What I would like to be able to do is toggle on/off search parameters in the Report Builder for a given report. I have a report which I use daily. There is a search parameter I which I want to be able to activate and de-active to get a certain view of the report. For example, I embed a keyword/tag in the Primary column…
-
Formula Imbalance
I know I've missed something basic here. =SUM([Contract Amt]1:[S- AWO $]1:[CL AWO $]1)-([Material Allowance]1:[Sub Allowance]1)/[Total FB Hours]) Thanks for help!!
-
Web Form - Can you add the discussion column as a direct field.
Hi All, When creating web forms is it possible to add the disscussion column directly onto the form rather than creating a seperate "comment" column for potential user responses. Reasons being, even with min 3 lines of text allowed in the comment box, its can still make a master sheet look messy and confusing with merged…