-
Consolidating names in a Columns
We use Smartsheet to manage several projects, with multiple and repeat customers. We need to create a report that reviews (2) columns (distributor and customer) from serveral sheets. We would like the end report to combine the (2) columns from all of the sheets and remove any duplicate names from each column. I have gotten…
-
Tagging Discussions and Dashboard Discussions
Is there a way to add Tags to a discussion that will also be searchable? The tags would be separated into 2 categories: * Followers: people who should follow, * Topics: Just different topics tag * Those users who are in the Follow category will get emails of either changes to the row/discussion/attachments The Dashboard…
-
Set Highlight Changes "as of" date/time
The highlight changes feature is fantastic...however, it would be very nice if you could set an "as of" date/time. For example I created a SmartSheet today and sent it to my team for feedback...I can't use the highlight changes now because everything I did initially shows up as a change. If I could set a date/time as of my…
-
Live Data Connector
We're considering upgrading to the Enterprise license so that we can use the Live Data Connector, but before we do, wanted to confirm if you can build reports against "Resource Views" data? From what I've read, can certainly author reports against smartsheets, and I suppose I could reconstitute the data that appears in the…
-
Set colors on cells based on value of another cell
Problem Statement: Based on New Hire Title, they are granted access to certain applications For example: If I select Manager from the title field, email, software, laptop cells will be highlighted as things that need to be done. Another example: If I select leasing from the title field, email, software cells will be…
-
Tab color
It would be nice to assign colors to sheet tabs for quick identification.
-
Calculating Years Of Service
Hi Everyone, I currently am importing a sheet to manage in SmartSheets and one of my cell formulas is not functioning. Can someone please let me know if there is a work around to this. Currently in excel I have it as a =datedif formula. Smart Sheet currently shows the following error in the sheet #unparseable. Thank You
-
Cell deletes the number 0
Trying to type in a number that starts 00070002654 but the first three 0's keep disappearing. Any suggestions
-
The new Find & Replace also allows searching within a Report!
Woo-hoo!!! Happy dance! Though I didn't find it mentioned in the release notes, the new CTRL+F will also allow searching of cells within a report. This makes our crew downright ecstatic!! Thank you, Smartsheet, for this seemingly simple, yet greatly beneficial, enhancement. Blessings, Loann
-
Tracking a Website Relaunch Project Management
I'm planning to use SmartSheets to track the activity for a website relaunch. The project would contain all the URLs for the site and the status for each page such as: 301 redirect, content refresh needed, Due Date, etc. Does anyone have a sample (screen shot) of the headings and layout they used to do this? Thank you
