-
Auto Number Formatting
Hello everyone:) I currently have a sheet populated via a web form. There are several people assigned to tasks. My goal is to have an auto number column to populate a prefix & suffix, based off the person assigned & their corresponding ticket number. I don't know if this is even possible. Lets say I'm assigned a task, the…
-
Wrapping cell text in reports
Hello all, I'm trying to build a Sight with several reports and noticed that I do not appear to have the ability to wrap the text in a report, is this true? It is making the layout of the sight much more difficult since a few of the task names and comments/updates make the report very wide. Plus it is hard to know how long…
-
At Risk Report with parent and only some select rows
Can someone please assist with reporting at risk line items? I have parent/child hierarchy and want to only report those parents that are over budget and only the line items under that parent that have fees greater than 0.
-
Issue setting up report for name off Contact List that has no hits yet
Is there no way to create a report pulling off someone in a column's contact list without actually having an instance of that contact being mentioned in the source sheet? For example, sheet ABC has an "Assigned To" contact list column that includes "Bob". However, Bob does not actually have any tasks assigned to him yet. I…
-
Formula to track % complete of a fabircation component in a row
Good evening, I will try and explain this without messing up * We are using smartsheet to track fabrication of product * each row is an item we fabricate * each item has a budgeted amount of time per task designated in a column * they are python, fit up , weld, unload, and admin * the sum of alloted time is *…
-
Master Roll Up Sheet and Reports
Hi there. I'm still rather new to using Smartsheet and am being tasked with really thinking outside the box to creatively build views and reports with Smartsheet. I am currently working on a project where we have 8 auditors (with 8 separate sheets of their own). Each of the sheets has categories and subcategories of the…
-
Symbols not showing in reports
I have a large Smartsheet grid that contains important information against a list of devices. Some of this information shows the status of some testing and is displayed as symbols. Rather than share the whole sheet with staff, I would rather share a selected few columns in a report. However, symbols & dropdowns do not…
-
Bug: Report Formatting
There is no conditional formatting The column in the Report was moved to next to the Sheet Name for illustrative purposes only - it has white background regardless of what its position in the column order is. Of all the columns shown in the second image, it is the only one that does not inherit the background color from…
-
Removing Multiple Link
I have created and tested a few examples of the master sheet where it links data from two base sheets. The bases sheets are maintained by my team and I don't require any changes. I have successfully done so but due to me testing a few times, the bases sheets are showing, each cell, data is outbound linked to <unknown…
-
Reports with Viewers
I would like to know if there is a way that viewers of the main sheet are able to work with the Reports. I know I can share the report but it seems they are not able to change the "What" choices. If this is not an option, would it work if I lock the columns and share the worksheet? Then would a collaborator be able to run…