-
Using the RYG "Yes, Hold, No Decision" and want to calculate based on staff assigned to
Our sheet has a status column with the RYG "Yes, Hold, No Decision" icons. There is another column labled "Staff" that lists which team the tasks is assigned to. I'd like to, in the Sheet Summary, Have a count and/or percentage of each yes, hold, or no decision for each type of staff selection available in that columns…
-
Formula IFS return values from other columns
Hi, i am trying to set a new column that should return EAS or ETS text depending of what it is in column named "ETS", but i want to add another if that return a value from column "Business Dropdown" if the column ETS is blank. This is the formula that i wrote now very simple and it is running well, but it is missing the…
-
Cumulative Column Query for Sheet A and Sheet B
Hello, I have Sheet A, which contains a column with work dates that have been inspected. I would like to create a cumulative column in Sheet B based on the maximum date from Sheet A. However, it appears that the current setup is cumulating all the dates in Sheet B instead of considering the maximum date from Sheet A. I…
-
Count Collect Contains formula
I'm trying to create a metric sheet to compile results from a number of survey questions. For questions where there is one answer per question, this formula works fine: =COUNT(COLLECT({Survey Intake Name}, {Days Remote}, [Answer1]3)) {Survey Intake Name}is the base value to count, {Days Remote} is the reference to the…
-
Permutation Generator
Hey Community - I couldn't score enough time at the formulas booth this week to pick someone's brain on this one. I am looking to re-create an Excel tool that I use to create all permutations from a two column matrix, for example, if I have two columns called SIZE and SHAPE, the next column should be a column formula…
-
How to count cells when they have multiple values selected, and I'm only wanting a specific one?
Because we can't use wildcards on the program, I am at a loss to set up a report that summarizes my sheet. I'm trying to determine how many entries are the 'Status' outlined in each Primary Column row, where the 'Suggest Solution' is the text in each column header. The 'Status' can only be one value, but the 'Suggested…
-
Is there a way to timestamp using a formula?
Apologies if this has been asked previously, I am wondering if there is a formula (or any other method) that can be used that can add a timestamp into a cell for when the workflow was triggered. For example, I have a workflow that sends an email to person 1 and i would like the date and time in a cell that this was sent to…
-
INDEX MATCH on multiple value cell
Hi, I have a column that can be filled from multiple items from dropdown list. On a second column, i'd like to return the matching items to those inserted in a first column. To achieve this, i have a second sheet with each individual item and it's match. Unfortunately when I try the index match formula, it only work when…
-
Formula with Symbols
Hi Smartsheet friends, I would like to use the red/yellow/green symbols, and need some assistance with the formula I have a series of checkbox columns; each column represents a task. When all are checked (true) = green When some are checked = yellow When none are checked = red Thank you! Donna
-
Formula to Update a % Complete on a Row
I have a project schedule with the % Complete, start and end dates. I have a checklist that is another Smartsheet used by another group. I would like to right a formula that will mark a task at 100% complete when the other checklist is complete by another group. It looks like that the % Complete column will not allow a…
