-
Can I partially mirror a sheet?
Hi, I hope someone can help me with this. What I'm trying to do is find a way to automatically share some information from a sheet into another. For instance, I want to have a sheet with all the relevant information for the company's projects, including financial information. Then have another sheet mirror most of it…
-
Project Time Tracking
Good morning, Does Smartsheet have, or plan to add, a timer feature for deliverables? Currently our project leads track their time manually or use programs such as the Outlook journal. I would like a feature in Smartsheet where a user can start a timer on a row and the duration would update each time a user starts and…
-
More suggestions/ideas
- A report that highlights broken links and cells with data in that doesn't conform to drop-down lists for the column. This would be really helpful for error checking in large scale set-ups. * * - The ability to format reports independently of their source sheets. * * - A few more system columns to help identify when…
-
Automatically archive info to new sheet once hit limit .. ?
Hello there, Was hoping someone could have some insight on this. We are looking to see if smartsheets can be the platform for an operators log.. the features of the dashboard and filters to help ease searching ... But our issue is; the size constraints .. we probably would use 5000 lines in a few weeks and to manually…
-
Enhancement request for SIGHTS: Metric-/SheetData-Widget based on reports
I'm missing the ability to insert data into Sights based on specific fields or ranges of a report. Currently one can "only" insert a report as a whole. If you want to show certain fields or ranges like with the metric widget or sheet data widget it is only possible to pick them from sheets, not from reports. Why is that?…
-
Enhancement Request: Sheet/Workspace Level References in Formulas
I would like to create notifications for the creation of new sheets in specific workspaces and in general better track what sheets are getting created where. To this point I would like to build a master sheet with drop downs for each workspace showing what folders and sheets are in them. A directory if you will. This would…
-
How to reference the <CELL ABOVE>
Is there a way to reference the cell above? example: =IF(logical_expression, value_if_true, <CELL ABOVE>) The simple way is to reference using [COLUMN_NAME]2 (the number being the current row number minus one). But this is broken anytime a row is deleted, which happens frequently on our sheet. I have tried adding an…
-
Enhancement Request: Viewer Security
I've requested associated items to this topic before. Here's two new ones: 1. Do not allow Viewer to Save As New. This one is pretty straight forward to me. Is there a Use Case where the Viewer SHOULD be allowed to effectively take ownership of their own version of the data? 2. Add Alert (Notification) when any user…
-
Dynamic lookup for Project Master Rollup
I would like to create a master project rollup to track projects, and do not want to set up cell linking every time a new project is added. To this end can we create a dynamic lookup so all the user has to do is type the name of the sheet referencing the new project into the master rollup?
-
email data from smartsheet nice visuals
Hello, we are looking for a nice visual way to email data from smartsheet to clients regularly, without having to take screenshots or do anything manually. any ideas of how to do this within an email body? Ideally we would love to email a dashboard but this doesn't seem possible
