-
Alerts not working
Hi All, I have a very simple smartsheet and if I add Yes in a drop down to a field (Output for Personnel File) then I want an alert sent. I have made settings unrestricted although the alert is to me and I am the owner. I have ensured that I save the data but nothing is triggered However, if instead of an ALERT someone…
-
Does using JOIN with the End Date field that is part of a dependency not work properly?
I am trying to MATCH on two fields, so I am using JOIN to make one field. The joined fields in my reference sheet are 1. a text field and 2. the END date field. When I MATCH to that JOINed field, I get #NO MATCH. But if I copy and paste that JOINed field into another field, I do get a match. Is that END date causing this…
-
Returning 3 results for approval results from multiple Approvers
Hi Everyone - First community post! I'm trying to work out a formula for the below scenario: I have an approval workflow set up for 10 approvers to one request. If everyone approves, I want to return a result for "All Approved" If everyone declines, I want to return a result for "All Declined" If no consensus is reached…
-
Count if
Hi I'm wondering if someone could assist me. I writing a count if for a column and it isn't counting the item if there is more than one answer in a row. Example would be =Countif([Case Type]:[Case Type], ="Birth Certificate". If you see below where Birth Certificate and SSI are in the same row, my formula is not counting…
-
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?
-
Conditional Formatting for Currency
I currently am working on a project that has currencies from several different countries and ideally I would like for each cost to show the correct currency symbol type without having to manually change each cell. Since most of the users are working from reports, even if they change the currency type in the reporat as soon…
-
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…