-
How to unselect an option under "What templates should this appear in?" in Control Center
Hi All, I'm hoping to unselect an option under the "What templates should this appear in?" in the Customize Portfolio Data section in the blueprint in Control Center. However, the checked options are greyed out and cannot be unselected. Does anyone know why this is and how I can unselect one of the options? Thanks!
-
How can I pull reports data from Resource Management connect to Power BI?
I'm not a developer and my knowledge of APIs are limited. I'm working on getting data from the resource management tool to power bi. I was able to pull all data, except for reports. I know I have to do a POST request, which I'm trying for the first time. I did run this query and I'm still getting errors. I'm getting this…
-
How to Generate List of All Smartsheet Objects I can Access?
Hello, I have records management policies and often need to get a list of all of the Workspaces, Sheets, Reports, and Dashboards I can at least view as an account member. I typically use the "Access.csv" report to do this, but it does not include a few useful things. I'm wondering if maybe there are workarounds I can…
-
Using a column date from sheet A to populate a dropdown in sheet B (Non data shuttle)
I'm looking for a way to populate a drop down automatically from data entered into a seperate sheet. We have a central "New Projects" sheet which acts as master data sheet. Several other sheets use forms that have a dropdown to choose the project, where the dropdown data is taken from the New Projects sheet. We have until…
-
What is the proper Content-Type string for an Excel (xlsx) file row attachment?
Hello, I have an Excel document (xlsx) that I want to upload to a row through the API. My code does successfully upload the file as a row attachment. However, when I download the file through Smartsheet and try to open it, I get an error "Excel cannot open the file 'file_name.xlsx' because the file format or file extension…
-
Formula for Different Calculations within one cell
I am attempting to determine spending, depending on the project status. I thought maybe the IF THEN formula would help, but I kept receiving errors when writing the formula. Project (Column A) Status (Column B) Cost (Column C) Spent (Column D) Based on the status provided in Column B, I'd like Column D to calculate Column…
-
Connect WordPress form to Smartsheet for Record Keeping
Is there a way I can populate a Smartsheet with entries from a WordPress form? We use the Gravity Forms Addon
-
Looking for Recurring Recurring Routine Tasks Solution
Longtime smartsheet user, close to 15 years, non developer/programmer looking for template/ collection/dashboard etcetera for routine daily, weekly and monthly tasks program. Built quite a few tools in the past that seemed to work but they always fell short hoping somebody in the community has a good answer. Examples:…
-
Clicking Data in Power BI and getting to the Data Source in Smartsheet
I have a Smartsheet data set. This data was connected to Power BI. I want to be able to click on some data, for example, a specific project number, in Power BI and be taken to the Smartsheet row. Is that possible? For instance, in Power BI, we used the data from Smartsheet to create a Top Ten list: Clicking on this project…
-
Help populating Make API Call module for Smartsheet
I am not able to correctly populate the Make API Call Module for Smartsheet I have established a connection with Smartsheet. I have created a trigger that activates when a new attachment is added in Smartsheet (and it works). For my purposes I am adding an attachment to a row. I have connected the Make API Call module to…
