-
Count how many times a word appears in a range of cells
I am trying to use a cross sheet formula to count how many times specific words in a range of cells. I keep getting a 0 and not sure why. Any direction will be greatly appreciated. Below is the formula I used. =COUNTIF({Touch Log - Detail Range 2}, FIND("Call", Submitter@row) > 0) I hope that the screenshots help.
-
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…
-
Count only child rows that have "Complete" in 3 columns
Hi I am trying to count the number of child rows that have "Complete" in 3 different columns. Here is my current formula: =COUNTIFS((CHILDREN)1, [HS Germ]:[HS Germ], "Complete", [HS Pave]:[HS Pave], "Complete", [Classroom]:[Classroom], "Complete") I keep getting "UNPARSEABLE". Any suggestions?
-
Does task info about being on critical path exist?
I would like to use something like =IS-ON-CRITICAL-PATH in a formula for the health indicator of a task. Does that function exist? I know Smartsheet can show the CP, but can a task identify itself for being on the CP or not?
-
Once I select a country from drop down, I want the region to be auto populated in the next column.
Basically if I select a country/group of countries from drop down in one column, I want the region/s to be auto populated in the next column. Is there a way to achieve this?
-
Returning a status if one cell within a range meets criteria
Hi, I am tracking some metrics using RYG balls. I have several parent metrics and child metrics under those all with RYG balls for a status. I would like the parent RYG ball to show red if at least one of its child metrics is red, yellow if at least one metric is yellow, and green if all are green. Does Smartsheet have…
-
Formula to Check How Many Boxes are Checked
I have a metric summary sheet that I am building to use as the point of reference for my dashboard. On my source sheet, I have a check box column for "Copy Needed." I want to count how many people requested copy needed when they made their request. So, ultimately, I need a formula that will pull back the total number of…
-
Formula Auditing/Evaluation
How do you audit or evaluate a formula in smartsheet? In MS Excel, you can audit/evaluate a formula to see the calculations for each step of the formula. I can't see a way to do this in smartsheet. I have a simple formula that should be giving me a specific value, but it's not, and I can't figure out why since I can't…
-
Look up table
Hello there, Recently I encountered a very strange and persisting problem in SmartSheet which I couldn't find a solution for. I wonder if someone can help me here. I created a lookup table which intends to grab a number, e.g. a hourly fee from a the table an use it in another location (another row, another column, even…
-
If then statement for contacts
I have a Zapier automation that automatically creates a new row with data about a new user. I'd like it to convert the username of the person who created the account into their SmartSheet contact. My issue is that I am not sure how to setup the formula to change a AD username to a SmartSheet contact. I created a separate…