-
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…
-
Querying a column from another spreadsheet
I have two tasks sheets. I use one to monitor "projects". I use another to monitor "tasks". I would like to add a column called "Associated Project" to the tasks sheet. I know I can go in individually to each cell and have it link to a cell in the projects sheet. I also know I can set up a dropdown list with a projects.…
-
Resource Check Out
Hello, We are trying to use a Smartsheet form for check out equipment from a drop-down list. Is there any way for the Form to not display an item is available for check out(I.E. remove it dynamically from the dropdown list) if it was checked out by a different staff member? regards, Brian
-
Metric sheet that feeds dashboards
Hello, I am looking for best practices for setting up a metric sheet to feed a dashboard. I haven't found anything in help. I've set up sheets with my formulas to pull data from various sheets and then use that data for graphs, reports for dashboards. I've caused myself problems while sorting and wondered if there is…