-
Improved Reporting Engine in Resource Management
Hi Community - We rolled out updates to improve your reporting experience in Resource Management. What's New: Faster Performance - Reports now run significantly faster, especially for large datasets. This performance improvement currently applies to Time & Fees and Expense reports, with improvements coming to Budget…
-
Auto-Populate Addresses using list of all addresses in our City?
We have a list of EVERY address in our city. It contains 455,598 rows of addresses (Woohoo!) That's a LOT of addresses, I know. It could be trimmed down to about half that if needed. We'd like to auto-populate fields in Smartsheet using those addresses as a reference point as the user types the address. How do we…
-
Report Builder - toggle column list order
It would be helpful to have a toggle (or some other way to make a choice) in the columns section of the report builder: Alpha or Sheet Order. Most reports mirror the layout of the underlying sheets to some extent, so it would be helpful to have the column list sorted in the same order as the columns appear on the sheet…
-
Order form: Select Multiple Items and Different Quanties. Simple right? Nope.
I need HELP! There is a department in our company that fulfills office supplies orders from other departments in our company. They want a simple order form that people can use to order supplies, using Smartsheet. Simple, right? Not to me😊 They’re looking for the form to look something like this: …that spits out something…
-
How can I get an average with a data set that needs to be grouped and summed first?
Hello! I have a smartsheet that records the status each project is in and then calculates the number of days each project spent in that status. There can be any number of status changes per project. I need to be able to average how long each project took and I'm struggling! I made a sample dataset below and showed the…
-
PMO Template - Deleted header row
Hi guys! I’ve been using the PMO template successfully for a while now, but this morning I accidentally deleted the Header info and now all of the metadata for the projects shows #REF for all of the fields. I tried to recreate it as best as I could, but it’s still off. Attached are what they look like. Normally I’m the…
-
Join us for the New York City Smartsheet Summit!
📣 Calling all project managers and portfolio directors! 📣 We are excited to invite you to join us at the New York City Smartsheet Summit on Thursday, Dec. 5! This partial-day event will be packed with valuable insights, networking, and hands-on opportunities to enhance your project and portfolio management skills. 📅 Date &…
-
Form URLs should automatically update on newly saved dashboards when copying a workspace template
As a user, I would like form URLs to automatically update on newly saved dashboards when copying a workspace, So that I do not have to manually update the Form URLs and prevent the risk of forms accidentally pointing to the original sheet or workspace. Please refer to case # 05972330, as this had been previously assumed to…
-
Formula Help
Hello! I am having some trouble writing a formula. I need to do the sum of Column A, if Column B = "x", but only if Column C is NOT blank. I'm using a calculations sheet to pull data from a larger sheet and the current calculation I have is =SUMIFS({Column B}, [Primary Column]@row, {Column A}) My [Primary Column]@row = "x"…
-
Google Slides/ PPT on a Demo on how to use Smartsheet
Hi All- I'm planning on doing a demo for my team on how to use Smartsheet and was wondering if anyone has any detailed powerpoints/decks they wouldn't mind sharing on how to use smartsheet. This would include step by step instructions on it's functionality and an outline on how it's set up. I know there are videos and…
