-
Expand Count formula (To provide a list of names from another column)
Hi All, This one may not be possible, but will drop it into here to see if it is, thanks in advance for your help. I have a "COUNTIF" Statement in place which is counting the number of times "Red" is listed in a column. In a corresponding column I have a reference to a company name which I would really like to display on a…
-
Change Date based on Symbol
Good day everyone, I've seen a lot of posts about changing a symbol based on the date, but none for the other way around. In my use case, I have a Priority symbol that is being filled in on a form. I need to create a due date based on the Priority chosen and the date the form was entered. I was able to build that initial…
-
Dashboard Chart to Show Rolling 12 Months
I created a sheet that has a primary column for "product type" and additional columns with months listed for the next two years (Dec '20, Jan '21, Feb '21, etc.) which indicates the month in which those products will be implemented. I then have 3 rows for 3 different product types. This data is pulled from a Summary Sheet.…
-
Are you able to pull emails from a Contact column?
I have a few sheets where I am needing to have the data Presented with the individuals name, then the email address in the column next to it. I have come across a few articles that have suggested having a helper 'Contacts Sheet' to reference w/ =INDEX({Contacts Sheet Email}, MATCH{Name@row, {Contacts Sheet Name}, 0)) for…
-
Using the Attachments, Comments, Proofs and Row Indicators Columns in Formulas.
Hi It would be really awesome if we could use the "Attachments, Comments, Proofs and Row Indicators Columns" in Formulas. Just as a reference point. "Like Helper Columns" Example, if there is a update request pending, I could then reference that column to do XYZ if there is or is no attachment. same with the rest of those…
-
Formula to count all instances of a value in specific column from another sheet
I am trying to create a formula that references another sheet and totals the number of times a specific value shows up in a column that allows multiple values (from a dropdown menu). I am using =COUNTIFS({insert reference to column on other sheet}, HAS(@cell, "insert specific value")), but it only counts the number of…
-
Why is my VLOOKUP not working?
This is the formula I am using: =VLOOKUP([ANALYST PARTICIPANTS]@row, {SAFFS::Firm:Analyst}, 2, false) I have a separate Smartsheet that has a list of Firm/Analyst names that I used Data Shuttle to make. It has an attached .csv file with the data. SAFFS is the name of this Smartsheet. The first part of the formula is fine,…
-
COUNTIFS error
So, a simple formula (that worked before), is now not working: =COUNTIFS([Approved 2024 $$]:[Approved 2024 $$], "", [Targeted Area]:[Targeted Area], "Atopic Dermatitis") Even if I reverse the [Approved 2024 $$]:[Approved 2024 $$] and put it at the end; it won't look at that column and count those "out". It just counts the…
-
Automation to change cell value not working
I have SCC setup to provision projects. Inside the project plan there is a variety of data coming from the intake sheet that will be used to determine what duration to pull from a separate master lead time sheet via INDEX/MATCH. The final lead times populate the Duration Planner column for every task. In addition, there is…
-
Symbol, Checkbox, Percent Complete formulas
I have a series of projects listed in a sheet (Sheet 1), each of the projects has a deliverable name. For each deliverable name I have a Symbol, a Checkbox, a Percent Complete, and the Person Accountable. In a separate sheet (Sheet 2) I want to return the results of the Symbol, the Checkbox, the Percent Complete, and the…