Best Of
ENGAGE 2021: Top 5 Things to Know Before the Show
ENGAGE is tomorrow! I’m so excited for you all to join us virtually for this event. Here are a few helpful tips for you to review before the show:
- Register for the Oct 19th ENGAGE event and access it here (Pro tip: if you registered for the ENGAGE event held June 8th, you're automatically registered for the Oct 19th event and can use the same confirmation code to log in!).
- Tune in at 8:30am PDT for the pre-show to meet our new class of Smartsheet Overachievers.
- Learn best practices from other Smartsheet users, including folks from Booz Allen Hamilton, Hydro Flask, Dell, and OXO.
- Can’t tune in on October 19th? Register here to gain access to the recording.
- Join the conversation on social media by using the hashtag #SmartsheetENGAGE (share your favorite parts of the show!).
We look forward to having you join us for our biggest event of the year! P.S. Thank you for all your wonderful questions in my last post, Bean and I were happy to help!
Jennie Ives
Join our Smartsheet ENGAGE 2021 Viewing Party!
Our biggest virtual event of the year is here- ENGAGE! We can't wait for you to tune in and hear from some of our best product experts- your fellow customers!
Interested in joining other can-doers during the show? Jump into our ENGAGE viewing party! This is your chance to connect, chat, and have fun with other Smartsheet enthusiasts! We will start at 8:30AM PT, 30 minutes prior to the event. This will give us a chance to settle in and give out some prizes!
Register today! We look forward to seeing you all there!
[Deleted User]
Re: How to delete all webhooks in bulk?
Here is a python script to loop through and delete all inactive webhooks. If you want to delete all active webhooks, change the line if j['data'][x]['enabled'] == False: to if j['data'][x]['enabled'] == True:
If you want to delete both inactive and active webhooks, take out that line all together.
Is it well written? Probably not. But it gets the job done.
Note: the 'whArray' will print twice. One will the IDs of all inactive webhooks. The second time should print blank if successful. This will also create a file titled 'SSwebhookdata.json' that contains all the data for the webhooks. Was this necessary? Probably not but it's the only thing I could get to work.
Anywho, enjoy.
import smartsheet
import requests
import json
smartsheet_client = smartsheet.Smartsheet('SMARTSHEET TOKEN HERE')
IndexResult = smartsheet_client.Webhooks.list_webhooks(
page_size=100,
page=1,
include_all=False)
results = str(IndexResult)
response = json.loads(results)
with open('SSwebhookdata.json', 'w') as f:
json.dump(response, f)
with open('SSwebhookdata.json', 'r') as string:
my_dict=json.load(string)
string.close()
j = my_dict
x = -1
indexArray = []
whArray = []
for each in j['data']:
x += 1
indexArray.append(x)
for x in indexArray:
if j['data'][x]['enabled'] == False:
whArray.append(j['data'][x]['id'])
print(whArray)
def deleteWH():
smartsheet_client.Webhooks.delete_webhook()
for each in whArray:
smartsheet_client.Webhooks.delete_webhook(each)
print(whArray)
print(IndexResult)
ducktapeonmydesk
Ask Me Anything! Jennie Ives, ENGAGE 2021 Event Team
Checking in with a short video message for you all! Drop your ENGAGE 2021 questions below once you watch and I'll be right there to answer. PS. Bean says hello!
Jennie Ives
Introducing our next class of Overachievers! 🎉
Please join us in welcoming our new class of Smartsheet Overachievers!
These customer champions come to us from all over the world and represent a wide array of industries, roles, and perspectives. They've been chosen to positively impact not only our product but our global community at large. Help us welcome them in the comments below and read their stories here!
Keep a lookout in our Community for tips, tricks, and best practices from this wonderful group!
Alison Clancy
Dark Theme - or other options - via User Options or Workspace Options
Would it be possible to use some of the CSS to control the color of the (currently hard-coded as the elements are rendered) cells and other backgrounds using the settings for "Personal Colors and Logos.." and the workspace colors and logos dialogs?
I have a browser extension for css overrides which I use to reduce opacity and blend-modes of all the white backgrounds, but it really would be nice to have a fully "dark" theme available to use while tap tap tapping away late at night.
I'm guessing there are some companies which would like to embed smartsheet charts, data, forms, etc.. into their online presence, but the hard-coded entities' colors are preventing them from doing so.
Ezra
Printing Grouped Reports
I have a report that i have used the new grouping function on and i'm wanting to print it with the group headings but each time i print as pdf or export it only shows the standard cells, without the group headings, is this correct or is there something i'm missing?
J.H.W.
Re: Why are unlicensed users asked to upgrade to Premium?
We just started rolling out smartsheet to our office. About 150 employees. We also went the enterprise route, and thought we had 'right sized' our licensing, based on the premise that the vast majority of users will be viewers only to the various sheets and reports. When I saw the 'upgrade' banner across the top of an 'unlicensed user' account connected with our domain, all I could think of is how our staff will feel. Bummed. We made an investment into the smartsheet platform, worked with smartsheet to develop custom API's, integrated Control Center... like I said, an investment. But from our staff's perspective, it will look like we cheaped out with some "free platform". I am posting this here in the hopes that this is being reviewed for enterprise clients with an option to turn this off.
Tim Starkey
Quick way to copy formulas across sheets I found
Problem: I had the need to copy a list of 26 formulas to 56 sheets maintaining the formulas for each sheet. to increase the data collection across the sheets. All sheets have the same column names. Smartsheet defaults to saving the end result, and doesn't offer the ability to just copy the formulas from one column in one sheet to another.
Solution: I found that if you type ' before the formula, and copy and paste the desired range between sheets, smartsheet doesn't recognize the ' and will post the formula from the cells. This way you can copy an entire rows formulas, and post the formulas into another sheet in rapid succession
L_123
Why are unlicensed users asked to upgrade to Premium?
Hi there,
Not sure whether this is request for change or an error in our licensing/configuration, but the unlicensed users in our configuration see a message that reads "You have limited access to Smartsheet. Upgrade to use premium features" whereas the licensed users do not see that message.
We have (we think) a properly licensed implementation of Smartsheet and that allows for a mixture of legitimately licensed and unlicensed users. The latter wonder why they are being asked to upgrade all of the time.
Advice?
Rob Hagan
