-
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…
-
Seeking Assistance with Smartsheet for Task Management
Hi all, I’m very new to Smartsheet and am keen to explore its features with the goal of eventually rolling it out in my work area. I have an enterprise license assigned through the Government. In our area—Media and Corporate Communications—we receive many tasks through Microsoft Outlook. These often include requests for…
-
Vendor and External Collaborator Management with Dynamic View in Smartsheet Gov
Join this webinar to learn how to use Dynamic View in your solutions to allow your Vendors and External Collaborators access to the information they need but not see the information they shouldn't. You will learn how to begin integrating the collection of external information into your organization's workflows in a…
-
Modern Reporting now available on Smartsheet Gov!
Hi Community, We’re excited to announce an improved, more intuitive way to create and update reports is coming to Smartsheet Gov. The new report builder makes it easier to understand, create, and update reports with an improved, more intuitive experience. Card view gives you quick and actionable insight into the status of…
-
Time Related Email Notifications
Hi fellow Smartsheet users, I have a Smartsheet setup where it will send an email notification when items are coming due. This will trigger when a value hits 30 days in a specific column. I went and opened this sheet for the first time in a while today and it sent me a notification that the item was coming due but the…
-
How to create a basic pricing estimate/quote with dashboard
Hi Everyone How can I create a basic pricing estimate with a dashboard for 4 major service offerings that I am sending to the government for assessment? It only needs to be simple, nothing spectacular. I need something that looks good at the very least with a few metrics involved because its still early days for anything…
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…