-
Using Smartsheet within Power Virtual Agent
I am using the Teams PVA to get responses to log into a Smartsheet form, however, when I go to sign in to Smartsheet within the PVA version of Power Automate, I get this error: Unable to deserialize cloned data due to invalid or unsupported version. Also, a window pops up for authentication but it is blank except for the…
-
Using System Column in Dynamic View
I have created a dynamic view which references the system column MODIFIED. Unfortunately, the optics of that column are not optimal. See screenshot. Any suggestions how to get this to appear merely as a standard DATE value?
-
How do I add iPhone home screen icon shortcut to directly open a form?
Saw it in the Smarsheet webinar that I just attended, but they didn't show how to do it.
-
Not Receiving DMs in Microsoft Teams
Hi All, I'm having an issue regarding my Teams integration. I have set up the permissions, but am still not receiving them. I have uninstalled and reinstalled the app several times, to no avail. I want to show a quick comparison based on the Help article. I am able to find the Smartsheet app in the Teams searchbar. But…
-
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…