-
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?
-
Formula Assistance for Returning a Due Date
Hello, I feel like I'm almost there on the formula, but can't figure out why WORKDAY is causing a #unparseable error. Function of the formula: If urgent flag is marked on the row I want the due date to be due on the same date that was by the 'Date Created' column type. If the flag is not marked, I want the formula to…
-
Calculating Age Monthly
I have a smartsheet with many events that often span several months. I want to calculate the average age of relevant events for each month. For example, for the month of March, I want it to calculate the age of all events that were closed within the month of March in addition to the average age (as of the end of March) of…
-
Date Formula Issues, Metric sheet
I am very new to smartsheet. What formula would I use to count how many times the year 2021 appears in the blue (parent) rows? I also would like to make a formula for a metric sheet that automatically updates as I add and delete years from my main sheet. What formula would I use for that part as well? I've tried a few…
