Best Of
Smartsheet Outage Banner: Please add one to affected pages/Plugins
When Smartsheet has an outage, yes, we can check status.smartsheet.com to check the status. However, I think it would be helpful to users in smartsheet to know when an outage affects what they're working on.
For example, I spent a long time trying to fix a bridge error I was experiencing yesterday. Today the Bridge flow works. It was only broken due to an outage I didn't think to check.
Request: Please add an "outage" banner on each affected page that the user can dismiss, when an outage occurs.
Further examples:
- Core application outage: Place banner on top of page for any user working on a Workspace item or the browse menu.
- Bridge Outage: Place a banner on every Bridge page.
- Workflows Outage: ALSO place banner on top of page for any user working on a Workspace item or the browse menu, including Automations menu.
Most websites do this. I hope Smartsheet follows suit for the benefit of its users.
NeilKY
Re: Recipient not receiving workflow notifications
Over the past few weeks we have started receiving this same issue. The notification/automation permissions are set to Unrestricted and the email address is valid. The user has not unsubscribed from the notifications and the email recipient is not defined as a licensed or unlicensed user and they are not a Smartsheet contact. Just an email address within our domain and the column is a contact column (it would have to be in order to be available to the automation). This function operates successfully 99% of the time and then fails on selected email addresses for what appears to be no reason. This has been reported by multiple sheet creators across different Smartsheets so is not isolated to a given user/sheet. Any insights would be appreciated!
Stu Benoff
Re: If you have Bridge, what are you using it for?
@Joe Goetschel great thread to start as I too am keen to learn how people are using Bridge.
I am only just beginning to use Bridge, a few use cases below:
- Since Smartsheet has no inherent way to filter on a dashboard, we have connected Smartsheet to PowerBI and have built dashboards in PBI with filters, complex charts etc. These PBI dashboards are in turn embedded in a Smartsheet dashboard for consistency. However, there are times when team members want to click on a link in PBI and be taken to the appropriate Smartsheet row/item. So I use Bridge to add a row link when a row is created in Smartsheet. That row link is then pulled into PBI so that users can click on the link which opens Smartsheet.
- I have used Bridge for daily "Today" updates as per this Help article
- I use Bridge to update dropdown columns as per this Help article, although I switch between Bridge and Data Shuttle when doing this (I find the latter is quicker to set up)
- Using Bridge for Row Autosort as per this Help article
I am not a programmer and don't have much knowledge around API usage etc. so a lot of trial & error and internet searching!
Neil Watson
Re: March Question of the Month - Join the conversation and receive a badge
One skill I'd like to improve in relation to health and Crohn's disease would be a deeper understanding of how diet and nutrition impact the disease. While I know that Crohn's disease is an inflammatory bowel condition, I would love to learn more about which specific foods and nutrients can help manage symptoms or even reduce flare-ups. There’s a lot of research out there, and understanding the nuanced relationship between food, the microbiome, and immune response in Crohn's could be incredibly helpful for those managing the condition.
AngB789
Re: March Question of the Month - Join the conversation and receive a badge
Great question! The one skill I’d like to improve is the ability to be more understanding rather than always trying to be understood.
Yvonne Smythe
Re: Help with COUNTIFS function
Thanks. The ranges are in the same sheet so not sure why the formula reference is showing two different names. I tried to recreate the table from scratch, and it seems to be working with the formula you provided. Your help is much appreciated
Eric Hall
Re: Count Project Categories + Count if Before a date
Try:
=COUNTIFS([Project Category]:[Project Category], AND(@cell <> "Complete", @cell <> "With Consultant"))
Paul Newcome
AI to Suggest and Explain Best Automation based on Description of Need
Hi Comrades
It would be very useful if the dropdowlist had the option to autofeed if values or names that are not included are added, with this option these dropdownlist would be automatically updated, like the contact lists
Regarding the automations, seeing how the AI is starting to be implemented, it would be very good if you could explain to the AI the type of automation you need and it would provide you with the automation that best suits your needs and explain it, not having to search among the many options that exist.
Best regards
Jacobo
Jira Connector should support syncing the Team field in Jira Cloud
My team are heavy users of the Jira Connector for Smartsheets. My company has recently moved to Jira Cloud. The transition of our connectors has gone fairly smoothly but we have found a few things that do not work the same. We are using the Team field in Jira Cloud extensively to identify work that belongs to teams and groups. We discovered that this field is currently not supported by the Jira Connector and will not sync into a Smartsheet. This is requiring us to re-think the structure of many of our sheets and also impacts our ability to make maximum use of the automated notifications that come out of a Smartsheet.
I think that the team field should be considered a critical field for synchronization form Jira Cloud into a Smartsheet.
Louis
Re: Sights separator lines
Another option would be to edit the title of the widget using the line and then make it bold, adjust font size, etc. That would keep your line the same size as the widget as opposed to having 2 separate ones.
I haven't tested this, but it seems like it should work.
Paul Newcome