-
If there are multiple batch numbers, how can I make that go to different rows instead of columns?
Hello, I am trying to create a form that allows you to enter in when you receive different batches. Sometimes we receive multiple batch numbers at once. Is there a way to make it so that if multiple batch numbers are chosen that all the data will copy to another row instead of another column within the same row? Right now…
-
Delay in applying conditional formatting
My conditional formatting changes certain rows and cells different colors based on the information in the row and it doesn't update the colors for a while. I will save and refresh and the conditional formatting still hasn't taken place. Any idea why that would be happening?
-
How to have only certain fields show on a form based on a condition
Trying to create One form where users can submit an enhancement request and based on the "Request Type" (a drop-down list), only certain fields will display and other fields will not display. For example, if a user selects Request Type = Report, then I want only report related fields to display. If a user selects Request…
-
Drop Down List assigning a score
I am trying to figure out the correct formula to execute an output I have created a Drop-Down list that the end user can select one or more options. Each question has an associated score with it (1 or 2). I want the output to generate the overall score and a background color in a separate column. I have it created in excel…
-
Conditional Formatting to add days to date based on risk category
Please help. I am trying to work with two columns: A Risk Category column which consists of High, Medium, and Low categories;. And a Committed Closure Date column which, depending on the risk category, is the date by which the gaps must be closed. Here is what I have which has not worked. The columns are already of the…
-
Date-Format Not Mail Merging Properly w/ Google Docs
Hello, I am using SmartMerge, to create a Google Doc from a Smartsheet. It's working beautifully, except for the date format not transferring properly once the document is merged. On my SmartSheet, the date is formatted as follows: March 14, 2023, but when I merge the document, it shows up on Google as: 03/14/23. If I type…
-
Document Builder: Conditional Formatting & Symbols
It would be great if document builder was able to: either apply conditional formatting within the builder or carry through conditional formatting from the source fields/sheets able to pull through field properties such as symbols as the graphical representation rather than the backend text e.g. I want to include project…
-
Change Milestone Diamond Color
Hi everyone, I realized this question was asked in 2020. Are there any updates on having milestone diamonds in a different color? Appreciate any suggestions! 😀
-
Conditional Formatting by Month
I'm creating a sheet that turns cells red when an item is due for an employee. One item is due anytime during their birth month - how can I format the cell to turn red on the first day of their birth month? Thanks!
-
Finite Dropdrown values?
Hello I'm was wondering, if it's possible to make a list of dropdown values available. But every time one value is used, it's removed from the list of possible options for the following row. Number 1, 2, 3, 4, 5... If I then use number 1, it is not possible to select 1 for the next row. If I then use the number 4, it is…
