-
Compare Contact Column vs Email contact Column
I am using the proof info columns, and sadly they only return the contact email. I want to compare this to a "Reviewer #1" contact column to see if everyone in the Reviewer #1 column has approved, I tried the following formula: =IF(CONTAINS([Reviewer #1]@row, [Approved By]@row), 1, 0) and it did not work. Any thoughts?…
-
Formula or Automation Help
Im looking for the best way to set up this formula/automation (whichever is best): I have multiple columns collecting different contact names by title from a form: I need a formula or automation, that when "Admin Reviewer" = yes, then it takes the contact in "Project Admin" and adds it to another column titled "PT Proof…
-
Index/Collect with Has while meeting specific criteria
Good afternoon community, I have two sheets where the first (we'll call this one Inventory Math) has a formula written to look at the second sheet (we'll call this one Inventory Cost). In this formula, we are looking for specific criteria on the cost sheet and then subtract from a specific cell on the math sheet. The…
-
Formula help needed: multiple combinations
Hello, I am in need of help with a formula. Basically, I have a formula looking at column A. Column A has 9 drop-down options, multi-select. Each of the 9 options has a specific (i.e., different) email associated with them. I have a large IF function that will accurately give the appropriate email, based on a single…
-
need help on a SUMIF formula to sum values if any of several drop down options are selected
I need a formula to sum all values in a column if that row has selected certain drop down menu options. The drop down menu is single select, but I am only interested in summing the values if the row has selected any of the first 6 options from the drop down menu. Here are the options in the single select drop down menu: 1…
-
RAID Risk Matrix
Hi, I have the below matrix, is there any easy way to get the formula to do the various risk levels (low, medium, high and extreme)? I have attempted to try with AI the formula but for some reason starting with the last scenario of Extreme it stopped generating a formula.
-
Why would the absolute reference change after sorting on a column?
I am creating a weighted score card. All my formulas appear to work as expected, with the exception of the Rank formula. Whenever I sort the sheet by either Team Member or Manager (both are setup as contact lists) the Rank function returns a #NO MATCH error for some of the rows. Prior to sorting, the RANK formula is:…
-
Formula columns not updating automatically after data is pulled in via datamesh
We discovered that our formula columns are not updating automatically after data is pulled in via datamesh and they only update if someone goes into the sheet, clicks into some cells, then saves the sheet. Support told me to set up an automation on the sheet that does something like locking then unlocking a specific cell…
-
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…
-
Parent Marked Qualified and changes status of all Children relation
If Status on the parent is marked qualified it will fill all the tasks below for this section only qualified. Which will stop all the alerts. How do I make it so it only affects this drop down and now all the ones on the sheet. And have this same situation going for all the dropdown
