-
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…
-
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…
-
Joining two columns together for rows that match criteria
Hello, I have a sheet with many columns from which I want to pull [Data]2 and [Data]20, in this format: "Data2 (Data20), Data2 (Data20),..." from another sheet. So far we have =IF(ISBLANK([Source1]@row), "", JOIN(COLLECT({Data2}, {Data5}, CONTAINS([Source1]@row, @cell), {Major/Minor}, "Major"), ", ")) And get Data2, Data2,…
-
Re-occuring "Row" event reminder
Allow a row reminder to be set to repeat, I.e., every 3rd Thursday, every Sept 1st, etc.… over a more extended period vs. one at a time and having to recreate it. The current process is a more involved task of creating a workflow and setting conditions for EVERY row that needs a reoccurrence.
-
Average Collect Issues
Hello! I'm trying to write a formula that will average the amount of time a type of request takes to complete by month. I'm referencing another sheet in this formula and just can't get it to work. Here's what I have so far: =AVG(COLLECT{Hours to Complete}, ISNUMBER(@cell), {Request Type}, "Quote Request", {Submitted Date},…
-
How can I pull only certain info into a report
Hello, Is it possible to only pull information into a report? EX: If my assigned to column is blank, I don't want that row pulled into my report, I only want the rows that are actually assigned to someone. Is that possible? Thanks in advance!