-
Show Multi-Contacts with a JOIN(COLLECT(...) formula -- working, but not showing as contacts
I have a Directory Sheet ('Sheet 2 -- Directory': https://app.smartsheet.com/b/publish?EQBCT=a3e35afe3e02404692195182d00936a4) with a list of Teams, Departments, and Contacts. I want to pull the Contact(s) into another Sheet ('Sheet 1 -- Pull Into Sheet':…
-
I need some help with custom rounding in decimals
Hi all, I am trying to find a way to use custom rounding within a formula. I've tried using the AI formula generator, but it ignores that part of my request. I have also searched for help online but no luck. Essentially I want to create the following custom rounding based on the outcome of a formula - Between 0.01 and 0.24…
-
Absolute Reference changes if cell is moved
Hi, Looking for help with Absolute references in cell formulas. I need the formula reference to remain the same even if the user moves or copies the cells to a different column. The scenario is Column8 has the formula =SUM([Column 6]@row, [Column 7]@row) If a user moves the Column6 cell to Column9 , the reference in the…
-
JOIN is missing items when joining multi-select dropdown column
I have a dropdown column (multi-select) that lists participating districts. Each row is a different program that can have different districts or sometimes the districts repeat. I am trying to count how many unique districts participated. In a separate column (dropdown - multi-select), I am trying to use JOIN to pull all…
-
Join Collect Formula not pulling contact info
I have a formula pulling contacts from one sheet to another that is working HOWEVER, it's not pulling them over as a contact with their emails attached and I have automations set up for email reminders and they won't be delivered because its not an email and just a name. Both columns are contact columns btw and everyone's…
-
Combining IF(AND and IF(OR statements
Hi all, I am trying to build a combined IF statement for a date validation field. Both of these statements work on their own. The first statement returns "University Holiday" if the "Preferred Date" is a holiday... =IF(OR([Preferred Date*]1 = "09/02/19", [Preferred Date*]1 = "11/28/19", [Preferred Date*]1 = "11/29/19",…
-
Formula Consolidation
This was originally a checkbox column to see if an estimated was within a 10% margin on either side, but now I need it to account for if it is under/over the 10%. Currently, three checkbox columns exist, with the following formulas: EST GOOD - =IF(AND([HR PER UNIT / EST]@row > [10% DOWN]@row, [HR PER UNIT / EST]@row < [10%…
-
Count how many per Month and Year for Summary Sheet?
Hey - I'm trying to create a summary sheet for photo data. I want to count how many Photo shoots are happening per month/year. The screenshot is below is our "Comp" sheet that has the data I want to pull for the summary sheet. So ideally, I can then create a graph for a dashboard. The AI generated this formula:…
-
Did changing the column title permanently break the formula from sheet to sheet?
I have a dashboard where I use a calculations sheet in between the dashboard and the sub sheets. For each, the formula is =COUNTIF({Type of Resource}, "Council Publication") with the item in quotes changing for each resource being tracked on different lines. The outcome continues to say zero, when there are counts to…
-
Using symbols for assigned to
is there a formula that automatically displays the person icon based off of the number of resources in the assigned to column vs using the drop down?
