-
Formula not updating
I have a very simple formula. =[Unit Price]@row * Units@row. It is suppose to take the unit price cell in the row and multiply it by the units cell in that same row. 9 times out of 10 it works fine, but every once in a while it wont update. This is causing us invoicing issues within out company as we have to go back and…
-
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?
-
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.
-
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…
-
How do I get a word count on a range of cells?
How do I get a word count on a range of cells? (Note: In the examples below, the text I need a word count on is in a column called "English" and the text I want to count is in rows 12 to 103.) I can get a word count on 1 cell using this formula: =LEN(English12) - LEN(SUBSTITUTE(English12, " ", "")) + 1 I tried replacing…
-
Changing status symbols if a task is not completed before due date
Hello, I recently found someone with a similar issue after doing a search in the Community and hoped it would help me but I haven't been able to succeed even though it got me close. Forum for reference:…
-
Find function stops working for contact type column
The following formula used to work but stopped working recently. Anyone encountered the same issue and managed to resolve it? =COUNTIFS([Assigned To]:[Assigned To], FIND("Name", @cell) > 0) "Assigned To" is a contact column
-
Extract Text with variation in "key words" from different cell
Hello, I am attempting to extract a variety of words sometimes in different lengths to another cell for consistency on reports, if possible. Not sure if I am overthinking this or making a 'newbie' mistake, definitely I am not a formulas guru but usually if I tinker long enough I figure it out. I am stumped. If it is not…
-
Weekly requests Received & Sent
Hello! I am trying trying to come up with a formula for a Sheet Summary field that can output the number of received requests and number of sent requests over the course of the current week for each member of my team. I have a [Received Date] Column and a [Date Sent] Column where the dates are inputted but I just need the…
-
COUNTIF for multiple locations
Hello SmartSheet Community, I need a formula that will count the total number of locations in a multi-select drop-down column "Placement Location" and if the "SPAH Responsible" column = "Fred". This is what I've been using but will not add multiple locations selected in one row. Do I need to add a sum formula in there?…