-
HELP. I'm a new user
Hi, I am very new to this program but found it by accident. It looked great to use for tracking recommendations and various projects. I used the free trial and it was great! I decided to invest since my job does not have a license. During the trial, I was able to print my documents, but now I don't see the print option. I…
-
Are you attending Smartsheet Gov Forum?
Are you attending Smartsheet Gov Forum, the inaugural customer event for users of the Smartsheet Gov platform? Let us know! Introduce yourselves and get a head start on your engagement and networking! Not registered yet? Sign up while there’s still space available to come sharpen your skill set, deep dive into the…
-
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! All attendees will receive a Gov Forum Attendee badge which will be showcased on your profile. Haven't received yours? Sign in to Community here and select "Request". We had a great lineup of speakers and sessions,…
-
COUNTIFS between dates & criteria.
Greetings Smartsheet Community, I am attempting to cross reference another sheet and Count all the Completed tasks within a certain time frame. So far I am successful counting the dates in the range using the following formula: =COUNTIFS({Range 1}, <=DATE(2018, 4, 31), {Range 1}, >=DATE(2018, 4, 1)) Next I'd like to add…
-
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…
-
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…