-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Enable multiple views of same sheet within a workspace
I have a sheet that displays information that is valuable as both a grid and a calendar. It would be nice to be able to make a "copy" that is a linked clone of the original sheet in a locked-view version of that sheet. For my use case, the main sheet would live as a grid, then a calendar copy could be made that is locked…
-
Translation Services
Seaking the ability for smartsheet to operate like many of the technology platforms, and have advancements, by allowing Forms and cell data to have translation possibilities . This could be on a form, that has a non english speaker the abilities to have automated translations of the text to their native language. Other…
-
Use generic name for Smartsheet automated notifications that can be easily updated
When I have changes in a number of Smartsheets due to personnel changes (terminations, new hires, promotions) I have to go through a large number of sheets to change the destination address for the notifications. For example, Kathy might be my accounts receivable person. When she changes roles, I need to change the…
-
Automation on Sheet Summary Fields
Workflow/automation based on sheet summary fields. One scenario - count of all cells, send a warning if the sheet is close to max. (Do not want helper column as that increases the count.)
-
Data Mesh Within data tables
I have information in data table A that I need synced over to data table B. The reports come from separate sources so they cannot be synced outside of Smartsheet. Another way of solving this would be allowing multiple connections per sheet. Both an add and update as well as a Look up.
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Lock Specific Cells
Currently the only option we have is to lock the entire row. Sometimes, I want people to change a value and have that change other cells and lock the values in after a submittal or an update without locking them out of the main cell they need to change. If this is implemented I would also like to see this option appear for…
-
Overallocation flag in sheets
Is there a formula or method to identify if a resource allocation flag is triggered for a given row? i.e. have another column in the same sheet that is checked/unchecked or true/false if the "red man" flag is on for a given row? I'm trying to figure out if there's a way to summarize all of the rows in our project sheets…
