-
Comparing one multi-select field against another
Hello Community! I wonder, is it possible to compare one multi-select field (array) against another and return TRUE if any match can be made between the two? Consider the following data set. Currently, I am playing around with: JOIN(COLLECT(Print:Print, MultiSelectData:MultiSelectData, {Returns True When ANY Match…
-
keeping information current / between two sheets
Hi, I have several worksheets, one being the master. I have figured out how to "copy" a line from one to the other, but when that line changes, it does not update the other sheet. How do I ensure the two stay in sync? as an example - in the secondary sheet, the line changes from planned to completed, but that change is not…
-
Is there a revised formula that will allow me to show more accurate training dates?
I have a formula in a training matrix that compares dates of when a document revises and when the training was carried out for employees. =IF([Revision Date]@row > [employee]93, true, false) However, this returns a red font date if the revision date is greater than the training date, even if the employee was trained prior…
-
Hyphens between combined cell data when not blank
Hi, I have the below formula to combine a number of cells together to make a naming convention. I want hyphens between each piece of information but only if the cell is not blank. We only have a Program Code 2 about half the time, I don't want an extra hyphen in there when it's a blank cell. The combined data at the moment…
-
CTC hours used by the task and role month-wise and visualize it
Hi, I am trying to figure out how to calculate the CTC hours month wise used by the task and the role seperate. Is there any way to find it using formulas or widgets? Appreciate your help
-
Analyse three columns content and produce a representation of request priority
Hi! TIA for any advice! I have a Smartsheet fed by a user form, that provides me with bookings for a service provision. As part of the service provision request in the service booking summary Smartsheet we have a department ID of the requester in one column, a "date created" column, and a column that shows the user/form…
-
IF Column Formula with Drop Down options
We are trying to create a formula that will recognize a service line type and auto populate the corresponding division in another column, but only for one unique circumstance. Only our Critical Care service lines also need to be Critical Care region. Below is the formula I tried, but when I make it a column formula,…
-
Formula to have status "ball" change color for blank cell
I would like to have the status "ball" color change to red if the column cell is blank and green if the column cell has a date entered in it. PLEASE HELP!!!!!!
-
If or Index or Match....not sure what to use
I have a Metrics sheet and a Source sheet. The Source sheet has 2 columns, Area and Status. On the Metrics sheet, for each Area, I want to display that associated Status. This is the Metrics Sheet (The % Complete will be pulled from another Source sheet): This is the Source sheet: I tried: Any ideas?
-
Using Row Comments in a Formula
Hello! I am currently working on a dashboard, and need to populate rows that have comments. Is there a way to do so or is there a formula I can use to indicate if a row has comments? I tried doing an IF statement, but I am not sure what the row comments would be referred to. Any information provided is greatly appreciated!
