-
Efficient way to make same change in multiple sheets?
I've created a Project Template that has been used for 40 Active Projects. When I am make improvements to the Project Template (e.g. Added Column, added Row, Dropdown List change, Conditional Formatting addition, creation of shared Filter...) is there any was to propogate the improvement to the 40 active Project Sheets? I…
-
LOST WORK
APPARENTLY AUTOSAVE HAS CHANGED WITH THE NEW UI. I JUST LOST A LOT OF WORK EXPECTING IT TO WORK THE SAME. THANKS SMARTSHEET. Be careful out there users.
-
UI "Enhancements"
I know I'm not alone in my dislike for the new "hamburger menu" feature. It has resulted in quite a bit of retraining at our facility, across all 3 shifts, sucking time from my already packed day. The additional clicks necessary to access "active" sheets for the day is almost exhausting. While I certainly hope Smartsheet…
-
IT Portfolio Rollup
Hi Community, There have been numerous posts about how to essentially rollup multiple smartsheet projects into a portfolio/dashboard to show overall status information about the portfolio. I get the essence of the various posts, but before going down those paths to figure-out how to build something from scratch, I'm…
-
New Features in Smartsheet
Hello Community, We recently updated Smartsheet to include some new helpful features. This update is centered around formatting improvements, and a way to give ownership of your sheets to other licensed Smartsheet users. Here's a breakdown of the updates: * You can now double-click on the Format Painter button to "lock" it…
-
Can you auto-replicate rows in a sheet based on a cell value?
We're putting together a Proof of Concept for our project management team. We're "this close" to being able to replicate all the functionality they need. But, we're stumbling on one item. They would like Smartsheet to automatically replicate a row when the value in one of the cells is set a certain way. Specifically,…
-
Column Not Found
Hello! When I am filtering down information from a sheet into multiple reports, a few of my columns are labeled as 'not found'. I haven’t renamed the columns, which I understand could cause this -although on one of the columns I changed the column type from 'symbols' to 'text' fairly recently (but not for my other one).…
-
Auto fill column?
Hi, everyone. I don't know if this is a possibility or not but I'm hoping someone can help. I'm looking to see if it's possible to set a formula/equation/conditional formatting so that what's entered in one column will autofill another. Example: I have a column called Access Requested (dropdown) and another called Type of…
-
Calculating a day from a date
I've got a column (called "Dates") formatted as dates. I would like the adjacent column to show the day of the week that date falls on. Using the formula =text((Date1), "dddd") brings back an #unparseable error in the cell. I've tried using brackets instead of parenthesis but it hasn't worked. I must be messing up the…
-
Translating Data from One Sheet to Another
I am looking for any method that could help me obtain the desired results. I have a tracking sheet titled “PM Sales Tracking” and within the tracking sheet there is a column that is called “Design Request” I have edited the column properties(design request) to a “dropdown list” with values of “yes and no” depending on the…
