-
Control Center Portfolio Workapp Blueprint - Remove assets from Workapp blueprint
Does anyone know if I can remove assets out of the Portfolio Workapp blueprint just for the workapps? I developed a large PPM program for my organization. Due to Portfolio Workapp limitations I need to remove some of the assets in the individual Workapp that were provision through control center. With out removing the…
-
Automating the Sending of Form Once a Cell is Designated as Completed
Hi, We would like to automate the process of sending a Form (survey) to a group once we have marked a project as "Completed" in a Grid/Sheet. In addition, we'd like the Form to prepopulate the name of the project for tracking purposes. I've scoured the boards and don't see any mentioned of this. Is this even possible?…
-
Advanced Search Functionality
Hi All, It seems as if you are unable to search by a row # or an advanced function in Smartsheet. For instance, if I have a customer that has multiple requests, when I search, I am unable to tell which one it is for, and I need to click on each of them. Is there a way to advanced search by the reference # that I have set…
-
Error 1008...
Hi Everyone, Ive been trying to automate a couple of imports to our smartsheet. Long story short, it is a JS script that takes a xlsx file extract taa from it and exports it to smartsheets. TBH ive been working on this project on and off for at least 4 months. As of now, the latest error im getting is this: Error adding…
-
20000 rows notification
I have a sheet that is fed from a form, will I get any notifications when the sheet is full or about to get full? If not, what is the best way to set up an automation or notification for that? Thank you
-
Outlook add-on: multiple-selection column disabled
I have a multiple-selection dropdown column named "Manual" on my sheet. When using Smartsheet's Outlook add-on to insert new rows to the sheet, the "Manual" column is disabled for selection. Any tips?
-
How to only view my own tasks on Google Calendar
I would like to be able to set up the Google Calendar integration so that it only shows tasks assigned to me on my calendar. I can't figure out if there is a way to do this without having to manually add my own tasks to a sheet.
-
Addon to export data in particular format!
Hello, I want to export data of a row(s) in certain format, is there any addon available for the same. Expectation is that once the data is exported it will take automatically take a predefined layout in PDF for the report. I will appreciate if anyone can directly help me on this asap.
-
Data Meshing from a report to another sheet wipes out the data
I created a reported and I then exported that report into Excel and then uploaded that Excel into Smartsheets as it's own sheet. I want to be able to data mesh from the report to the target sheet, but even though it's identical information when I data mesh it wipes out all of the information from my Assigned To column.…
-
Global Update Find/Replace for a checkbox column?
I'm trying to run a Control Center global update to Find / Replace a value in a checkbox column. I want to find certain rows and if the checkbox column is unchecked, to check it. I've tried a few different combinations of settings, none of which have worked. See my screenshot for my most recent (failed) attempt. Any advice…
