-
Formula to change the color of a task name or date cell, based on another date cell
Hi all! Theoretically, I'd like to state: If the cabling will be delivered, but it won't arrive within 14 days before the date of installation, then change cell color of these tasks below to indicate the need to order temporary/alternate cabling solution. I realize it may be too dynamic to only be set-up in conditional…
-
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).