-
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…
-
Auto Date Calculation
Hi Very new to SmartSheet, I am trying to create a Purchase Tracking sheet that can be used for Payment Schedule. Here is what I have " Invoice Date" This I put it manually whenever I receive an invoice from my vendor. I also have another cell "Droplist" which state payment terms like 30/60/90 days. What i need is 1) A…
-
Convert multiple text dates to a date field in a single cell
I have contract information entered into my sheet via Web Form. The users are allowed to enter multiple products in at once but asked to keep information pertaining to them in the same sequential order throughout the form entry. I am looking to see if it’s possible to take multiple text dates entered in a single cell and…
-
Limited Access to Report Builder
We have been using a very simple report to pull information from a single sheet. The report has been working fine for several months. Today I was notified (& verified) that I am the only person who can still edit the report via report builder. Everyone else is stuck viewing the information I last searched for and cannot…
-
Newbie Question - Reports Lookup into Sheet (relational database like)
First, I am sure this has been answered, but I could not find it. I have two smartsheets: Projects and PMs. The PMs sheet has basic info about the PM (Emp ID, Name, Email). The project sheet has all the projects we are working in the company with lots of project metrics. One being Margin %. I want to create, then run a…
