-
Highlight duplicates across multiple columns
I think I already have the formula working for my Number column, but I would also like it to check additional columns "Number Field 2" "Item Number" for duplicate values. Not just checking for duplicates down one single column but occurring in any of the fields and highlighting those occurrences. I hope that explains what…
-
Percentage (%) complete formula
I'm using this formula suggested in another thread to calculate the percentage complete for particular tasks: =(Today()-StartDate)/(EndDate-StartDate) What I'd like to know is how to cap this at 100% because I don't want the percentage to keep increasing the further past the completion date we go. Any ideas?
-
If condition for Symbols in Smartsheet
Hi Smartsheet Community, By any chance, is there a possibility to create automation here wherein if a user ticks all 9 stars, the status will be tagged as "Completed", else it will remain as "In Progress". Thanks for any help you can provide. -Mart
-
"If" formula - Auto populate a defined text if a cell is blank?
Hello - unsure if I'm even using the right formula here, but I want a cell to populate the word "Requestor" if the cell is blank, and keep whatever is populated... if not blank. Or is there a way for a column that is currently a single select dropdown to default to the option "Requestor" and then would be changed if needed…
-
IF formula to pull biweekly updates
I'm trying to create a form that I send out to partners on a biweekly basis. I'm working with partners from 5 different countries, and I want their updates to be pulled using the sheet summary into a dashboard. Is there a way to do an IF formula with an INDEX formula to get the following results: IF [Country] is listed as…
-
VLOOKUP #NoMatch has me completely stumped
I have a vlookup formula in my sheet (Project Plan) that references another sheet (Phone List). Despite triple checking formulas, spelling, spaces, etc. I could not get the formula to return anything by #No Match. I copied and pasted the original sheet (Phone List) that's referenced into a new sheet (Copy of Phone List)…
-
How to duplicate the formula that sum across multiple sheets
We set up the sheet to report the daily sale volume of each project in the department. Each sheet is for one department. We create duplicate sheets for all departments in our company. Please see the screenshot. Now, we create a similar sheet to calculate the sum of the sale for each project for each day across all…
-
Parent/Child with Nested IF Statement using CONTAINS
I have a multi-select dropdown column in my worksheet called "Interdependencies." The sheet has parent rows that cover a main area with various child rows that cover discrete tasks. The dropdown options are: Learning Offers & Pathways B2C Partnerships Student Success Phase 1 Credentials + Employment Marketing & Demand Gen…
-
Ancestors / Parents and concatenation of all level to make a string / map of the heirarchy
Hello smartSheet world, Can we concatenate all parents in a Column/field values together? Example, If we have 5 levels; 123 ABC abc 987 i As descriptive text in each field (e.g. a Name of a WBS Level in a Project.) Using the above to make the below adding a " " in between each (Could be any character) "123 ABC abc 987 i"…
-
Join Collect Formula with Contains?
Trying to figure out the following formula but am having trouble getting it to work: =JOIN(COLLECT({GHL Maintenance Range 1}, {GHL Maintenance Range 2}, CONTAINS([User Email]@row), ", ")) Basically trying to a join collect which is simple enough, but I want it to count if the user email is Contained in a cell where there…