-
Card View is great for sheets. Please bring to reports, too.
Love Card View! I can definitely see using it. My issue is that I do almost all of my viewing in Reports as opposed to Sheets because I work across many sheets for my work, consildated into Report views. I know there might be complications to implementing this, for example when a sheet included in report does not have a…
-
Capturing Date of Transaction
Greetings, I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer". I tried modified date but that field gets changed too often to accurately reflect the state. Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell's…
-
How to Create Tend Arrows with a Function
I have a cross sheet table with data displayed on it that works fine. Just wondering how I can display a trend arrow using a function for Up, Down and Across. Basically, I am measuring KPI performance against the number of days since the last time we had for example a Lost Time Injury or as is known as an LTI. This work…
-
Contact Columns not available in POwerBI when multiple contact enabled?
Whenever I enable a contact list to allow multiple contacts (New feature Oct 2018); the power BI column display balnk for all records. Happens after enabling this in the columns and adding multiple contacts in any cell.
-
Using Trend Arrows
I have a formula which works out the Net Days since an event occurred. I have the following: [Event Type], [Days Since Last Event], [Day Before], [Trend] The [Event Type] is the event I am searching for the number of days since the last one occurred. The Number of days appears in [Days Since Last Event], is a formula which…
-
Help Needed: Creating more efficient ways to update sheets
Hello, I am working on providing dashboards for my seniors. Here is the premise: I have multiple project managers (PMs) that work with four different agencies. Each PM has their own assigned sheet and assign an agency to the project. To create a dynamic dashboard, I am using a separate sheet (a table sheet) that pulls info…
-
WorkFlow with a Report Form
I have reporting into a Register working just fine now. Now I need to send out another report based on an item that has occurred within the main register. i.e. A New Hazard has been reported. The report populates the main register but some items need to be worked on and this is typically carried out by a manager. Their…
-
Populating Sheet Column Content from Report
We are using a unified Asset Tracking sheet in smartsheets for multiple types of Equipment (i.e. Phone, Computer, Printer, etc...). This sheet has basic Asset Tracking information in it but we need to gather additional equipment specific to each type of equipment as well. We could create a column for each in the Unified…
-
hh:mm:ss Time Tracking in Smartsheets? (Probably not possible)
Howdy everyone! I've got a pernicious little problem that I'm wondering if anyone has any ideas about. My team and I currently track all of our break/fix help tickets in one dedicated "backlog" sheet. Each task that we need to complete is added to this sheet, gets prioritized, gets worked on, gets clarified (if needed),…
-
Number of NetDays since last event
Hi, Looking to calculate the number of netdays since an event was recorded. I have a {Date of Incident} column and a {Classification} column Looking for the number of days since a specific classification was reported i.e. {Classification}, ="Lost Time Injury". Want to be able to report this as a Key Indicator of No. Days…