-
Merged: Printing format
This discussion has been merged.
-
Remove smartsheet email in mod by column?
Hello, Simple question that im guessing is no but is it possible to stop or remove the automation@smartsheet.com from showing whenever an automation happens? I have a modified by column and it doesn't really do anything if it always says automation instead of the actual person who modified it.
-
Notification sending to both people not just 1
Hello, I have an automation set up to notify certain people if text is entered into the cell. While both parties can enter in text into the cell I only need it to notify person 1 when person 2 enters in text. Currently it is still sending notifications to both themselves and person 1 when person 2 enters in text. Person 2…
-
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…
-
Error when submitting a form.
Workspace owner has created a form and published it. Users that are members of the workspace receive an error when attempting to submit the form. Error message is: There was an error submitting the form. Please try again. If the problem continues, please visit www.smartsheet.com/gethelp. The user/owner of the form has…
-
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…
