-
Pivot Tables on Dashboards
Has anyone found a way to display a Smartsheet pivot table on a dashboard? I have created a pivot table that summarizes my data, which include multiple lookups and would like it to appear on the dashboard.
-
Blueprints not launching
Hi there, having an issue with the smartsheet control center and I hope someone can help me out. Everything required is build (blueprints, intake sheet, workspace for target project folders, source template folder). If I'm stated within the intake form as the "Project Manager" the blueprint gets launched and everything…
-
Pivot App - How can filter a field
Hi there, I'm new using the Pivot App and I was wondering if there is a way to filter any of the fields in the pivot table. I have an excel pivot table that I'm trying to replicate in smartsheet from a master data that already is imported into my smartsheet. There is a column in the data master named "Current Status" with…
-
I get a "bad request" error when trying to link a smartsheet report to Power BI?
Is it because there is a link to the sheet within the report results. DataSource.Error: Web.Contents failed to get contents from 'https://api.smartsheet.com/2.0/reports/4021593383954308?pageSize=500' (400): Bad Request Details: DataSourceKind=Smartsheet DataSourcePath=Smartsheet…
-
Check previous values in transaction against current value
Greetings, I have a sheet that collects transaction via a form. Each new transaction is added to the top row so I can pull vlookup to populate various other sheets. I'm trying find a formula that will compare entered transactions against prior entry of the same item. Using example sheet shown, if the "Tag Start" value for…
-
Has anybody used Smartsheet to create schedules for Procore?
My company uses Smartsheet to create its construction schedule that is then uploaded to Procore. However, there are some problems with the integration of the two. To upload to Procore the schedule has to be exported as a Microsoft Project file (.xml) and then it can be uploaded and processed by Procore. The problem is that…
-
Yammer Feed
Does anyone know how to add a Yammer feed into a Smartsheet Dashboard? I have tried the interactive web content widget, but the URL wasn't supported. Any ideas?
-
How to set up 10,000ft to clock a user into work when scanning a barcode
Good Morning, I am trying to set up a Smartsheet and 10,000ft integration where when a licensed user scans a barcode, it puts them into work, at the pay rate established within roles, against a specific piece, and then feeds the hour and rate totals for that piece back to Smartsheets. I have not messed with this part of…
-
How to get VLOOUP to skip an instance if specific condition not met?
I am getting out of my depth and would like some help with a complicated equation. Background Info: Trying to streamline an item check in/out system that uses barcode SKUs and an item condition as a freeform explanation from the user. An item can be checked out/in by users and when they are checked in it will prompt the…
-
When to expect @mentions to work in Dynamic View?
We use Dynamic View to review HR requests. The comments are used by budget and HR to discuss the status of the HR requests. We occasionally need to ask the requester a question and would like to use @mentions to email a comment/questions directly to an individual. Any update on when this will be implemented?