-
AutoNumber systemColumnType via API
I am trying to add a AutoNumber column type to a sheet It seems to work just fine The issue I am having is the "autoNumberFormat" seems to be ignored. I can go into the smartsheet.com and manually edit the prefix, and suffix, and starting number in the sheet and it works fine… but the API isn't applying this on column…
-
"autoNumberFormat" seems to be ignored
I am trying to add an AutoNumber column type to a sheet It seems to work just fine The issue I am having is the "autoNumberFormat" seems to be ignored. I can go into the smartsheet.com and manually edit the prefix, and suffix, and starting number in the sheet and it works fine… but the API isn't applying this on column…
-
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 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…
-
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…