-
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…
-
Returning A Symbol Value From Another Sheet
Hi all! I am trying to return a symbol value from a cross sheet reference, and I am having a little bit of difficulty at the moment. I have 2 sheets, we'll call the first sheet (that I am trying to reference) "Trends", and the second sheet "This Week". In "Trends", every row represents a week, and ta the end of every row…