-
Thanks to all who attended Smartsheet Gov Forum!
Thanks to all who came out to learn, share, and network at the second annual Smartsheet Gov Forum last week! We had a great lineup of speakers and sessions, including Smartsheet experts as well as customers across all levels of government sharing their best practices and learnings. Attendees dove into sessions from dawn to…
-
Welcome to the Government Community!
Hello! This is a space for Smartsheet and Smartsheet Gov users that work in all levels of government to connect, share ideas, challenges, best practices and how you are using Smartsheet and Smartsheet Gov to create impact. My name is Chris, I lead marketing for the Smartsheet Gov platform and am excited to get to know you…
-
Hide comments in a published report?
Hi there, Is it possible to hide comments in a published report? I see this is an option when publishing a sheet as "Read only - HTML", but this option does not appear to be available when publishing a report. There are comments in our main sheet that the report is built on which we do not want to be visible in the…
-
Registration for the 2025 Smartsheet Gov Forum is now open!
Tired of the grind? Ready to maximize your impact in government? Registration is open for the 2025 Smartsheet Gov Forum! This can't-miss event is designed to help you work smarter, not harder. Date: Tuesday, May 13 Location: Convene, 30th floor, Arlington, VA Time: 8 a.m. to 4:45 p.m. At the Smartsheet Gov Forum, you’ll…
-
Any local government users in Ohio?
Our office is new to Smartsheet. I would love to connect with other local government users in Ohio and find out how you are using Smartsheet.
-
Local Government Uses
I am a Mayor of the city in Washington. We are looking at Smartsheet to add as a project management tool for staff. I am interested in how other local governments are using Smartsheet? Specific areas of interest are Capital Projects, Human Resources (Performance Reviews?), Permit Tracking, and Finance. Brett
-
Conditional formatting to apply a color gradient based on cell contents?
Hi there! Google Sheets have a very useful feature that lets you set a conditional color gradient (i.e., white to red, or red to green shadings, etc.) that adjusts based on either min/mid/max values or based on absolute values. Is this kind of thing possible with the existing conditional formatting feature? Or would I need…
-
Notifications to Microsoft Teams Channels in Gov is now available in Smartsheet Gov!
Hi Community, We're bringing Microsoft Teams to Smartsheet Gov! We are making notifications to Teams Channels available on the platform for the Gov Community Cloud. This will empower our Smartsheet Gov users at most civilian federal agencies and state and local government institutions to start transforming conversations…
-
V Lookup formula for importing Contact List broke and I don't know why.
So I have a reference sheet of contacts and their assignments. I made a different sheet to assign tasks as they come in and set up an equation to look up and auto assign. It looks like: =VLOOKUP([Rule Number]@row, {Committee Range}, 2, false) So when a task came in and it matched the rule, it would assign the person in the…
-
Gov connection in Power BI?
Is there a way to make Smartsheetgov data available in Power BI? The existing Power BI Smartsheet app/connector only seems to connect to a Smartsheet account, but not a Smartsheetgov account, and I don't see any way to customize it to change the connection string. I do see that the "differences between smartsheet gov and…
