-
How to generate unique values for the Primary Column
I'm new to Smartsheet and experimenting, and I hope this question makes sense — tell me if I should be trying a different plan I have a sheet and I have what I think of in database terms as a composite key, that is what makes each row unique is the Member Number and the Event. I know that I can't define a primary column as…
-
Procurement
I'm interested in how people are using SS for procurement and grant management in government? Are there templates you have found especially useful or have you made your own? I transferred to a new division a year ago and they had made their own. I'm hoping to eliminate duplication and help add automation to future…
-
Smartsheet Gov and the Engage Event: Real-World Value?
Engage is a great opportunity to learn about exciting new feature releases and hear from experts and peers about their experiences with Smartsheet. However, I recently started working with my first client who transitioned to Smartsheet Gov, and there are many features and functions they no longer have access to.…
-
What does your Smartsheet maintenance team look like at your organization?
Curious to know how many employees manage your Smartsheet (and Resource Management module if applicable) system and how many licenses you have?
-
Moved: formula that determines how many working days 2 tasks were in progress at the same time.
This discussion has been moved.
-
Hello Gov group!
G'day, y'all. I'm a Smartsheet-designer-to-be, I think. I was an Access developer back in the 90s and 00s (and other databases before that). I've been doing Business Analysis and app design and process redesign and change management, and whatever else was needed, my whole career. For the last X years, I've been…
-
Trying to increment a value by 1 each day, based on a specific status. - GOV
Each day that a row is in an 'In Progress" status, I want to increment a counter to determine the # of days in progress. So far I have tried an automation that runs daily and filters based on the condition. But I am not finding a way to add 1 to the counter. I have thought about doing a function but can't find a suitable…
-
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…
-
Smartsheet Dashboard - Chart Colors Changing
Hi Everyone, This is actually my second post and 3rd issue I have had on this topic. My chart colors won't stop changing when values go to 0 then back to a positive number again! My 1st solution attempt I tried adding +0.0001 to the end of each formula, but this kept multiple 0's on the display which made part of my chart…
-
Introduction of self
Evening all, My name is Darren Smith and I am a park ranger at a US Army Corps of Engineers lake in South Central Kentucky. We are moving from Microsoft Access to Smartsheets as a way to keep up with our customers and their permits/license/trespassess/ etc. Just getting started and really don't have a clue what I'm doing.…