-
Linking data by Primary Column
We track data for customer accounts in a couple of different categories. This inevitably means that some customers (not all) appear in both data sets. We spend some time ensuring that the data entered is consistent across both, but this is a manual check. It'd be good to be able to 'link' data between sheets conditional on…
-
Merged: Increase the cell count limits
This discussion has been merged.
-
How to add time or subtract time from a date when "check" is selected?
Hi! Looking to see if this is possible. I have a packaging release date column that current pulls from another sheet for all items. I have items for Disney that I need to subtract 30 days when I click Disney checkbox column. When I uncheck the checkbox column, I want the date to revert back or add 30 days back. Here is the…
-
Formula Issue
I want to get a dollar amount based on if a checkbox is selected. I am running a program where participants can get gift cards as incentives. I am using a separate sheet for the amount for each incentive. The other sheet columns are named the same as the incentive. Each column is a checkbox. To explain what I want, let me…
-
Smartsheet Gov JAWS (Screen Reader) Computability and Accessibility
In the current build of Smartsheet Gov, the highlighted cell in a sheet does not have the cell text / input connected to the name of the cell to be read by a screen reader. Three different screen reading software's were not successful in trying to read aloud the text in the highlighted / in focus cell. Having this issue…
-
Workflow not sending emails
I have a very simple workflow that is not sending email when rows are added. I have been testing with me doing the entry and I don't get emails. My notifications and Automation Permissions are correctly set. Can anyone provide insight or suggestions?
-
From another sheet, how can i lookup / pull a list of values ?
Hello world, I have two data sheets that both have columns that contain a identifier for what the row references. I want to make a list in my third sheet that contains all the identifier values of these two data sheets that meet my criteria of containing letters xx in the end of their identifier names. Is this possible?…
-
External Communication
A way to communicate with external clients without letting them have access to the sheets (Without using proofing or having to create a dynamic view for every project).
-
Trying to Figure Out Scripts
Hey all! I must preface this by specifying that I am a complete newb when it comes to Smartsheet. I know the very absolutely basics, but am now trying to learn more about it. The issue I'm trying to figure out is keeping track of multiple packages I send out a week. I wanted to see if there's a way to write a script where…
-
Multiple Filters In Reports that Collaborators can Choose/Select
I want to be able to develop 1 master log and create reports and forms for employees to use to change or add data. In order to change filters, I believe you need more permissions than an editor. To follow through with my idea, the editors would need to be able to change the filters. What if we had the option to lock or…
