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…
I would love to see rich text formatting be available in cells on a sheet. We have several reports where we rely on certain words in a cell to be a different color than the other words in a cell (quickly showing variable options or redlining changed content if only a word or two has been altered). Currently, we are only…
Creating Dashboard, Sheet to centralized all links to other sheet in a Workspace. I need non Smartsheet user to easily navigate from sheet to sheet to collect data from them. My tasks: Creating Workspace out of a template. Publish sheet Insert hyperlink to freshly created sheet/Dashboard Share Master sheet to non…
System Field that captures who the current user is so you can use formulas or logic based on that.
I would like to view rows grouped by their category (from a dropdown column) in Sheet form, so that I can add new rows while viewing my data in an easier-to-read format. Currently it seems grouping can only be achieved in a Report which does not allow me to add new rows. I am new to SmartSheet but have intermediate…
Add an option when using automation to move/copy a row to add the row to the top of the sheet.
This discussion has been merged.
Hi guys, my idea here is to use the stored information in a cell value. Let's say that the first time this cell was changed is important to me and I want to store this value in a different column in my sheet. I would then use a formula to get this stored information, for example: =GETCELLHISTORY([info], [position]) info:…
It would be very helpful to export a list of people/emails shared to a WorkApp and their role to match up to company lists. We use groups as much as possible but we still have a ton of others listed. It's difficult to scroll through - it's not even alphabetical (that would also help). It would also be amazingly helpful to…