-
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…
-
How to add hours in the column if date format is in text/number?
Hi All, New here in Smartsheet. I would like to ask what formula can I use in column 5 to achieve the expected date and time if I add column 2 and column 3. Current Formula in column 4 is =IFERROR([Column 2]row 3 + ([Column 3]row3 / 24), 100) If I put in actual excel file it is working as per expected result in column 5…
-
Formula
I have a series deliverables reference from another sheet (sheet 1). In this sheet (sheet 2) I list those deliverables under an objective and I want to rate the entire objective based on the highest risk in my Symbols (Red being the highest risk, then Yellow, Green, Gray) what would be the formula. Same thing for the…
-
Need Formula to Match Names in 2 Different Sheets
I have a list of people in one sheet and I need to know if the names in another sheet are included on the main sheet. What's the easiest way to go about this? The tricky part is on the source sheet I have a column for first and last name, and the supplemental sheet that I need to check against has separate columns for…
