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…
Jira Connector for Smartsheet Gov
Would like to be able to use this feature in the government environment.
Tracking Employee Effort Across 170 Projects
I have a little experience using Smartsheet in my previous role at FSU and am now trying to help them adapt to some (unforeseen at the time) scaling and relational issues on the sheet/form I built. Specifically, this tool has been implemented as a way to track effort/time on a large 5 year federal contract. Our current…
Representing Milestones landing in Financial quarters
Hi, I'm new to Smartsheet and hoping that what i'm trying to achieve may be possible but have drawn a blank on the help and community topics so far. I need to be able to represent that a project milestone is landing in a specific financial quarter and then have this represented on the Gannt chart. Ideally i would have…
Can you publish Smartsheet Dashboard without sharing underlying Google Sheet data source?
I want to publicly publish a Smartsheet Dashboard as view only and import the data from a live Google Sheet so that it updates in real time. Before I do so, I want to confirm that if I publish this dashboard as view only that the public won't have access to the Google Sheet data source. They should only be able to view the…
ODBC Connection with Visio
Hi All, I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to create several reports and tableau dashboards. In Visio, you have the option to create an…
Same login for Control Center Gov and Commercial?
I understand that an email address can only be connected to one Control Center account, but since Gov and Commercial are separate, can the same email be used in both environments to create separate blueprints or do I need separate to use two email addresses? (ex: company commercial vs. client gov)
Card View for Reports in Smartsheet Gov
Hoping this is easy- Card View for Reports seems to already be available in Smartsheet. I'm working with Smartsheet Gov and it is not yet available. Please add to smartsheet gov.
Decrement a funding total
Hello all you formula wizards ~ I'm down to the last test of a travel request module and I realize my formula is not working correctly so I'm looking for some guidance. I have an intake sheet where requests are submitted, then reviewed and approved, which moves the data to another sheet for further approvals. I need to be…
Using App to Schedule Resource
I am using Smartsheet to create a calendar system for reservation of a shared resource. So far, I have not been able to find a way to add TIMES to Smartsheet so more than one person can schedule the same resource on the same day, during different time slots. Can you help? Furthermore, these resources are occasionally…