-
Formulas: Use of IF and JOIN
I am not the most savy when it comes to complex formulas. I am trying to figure out if I can combine an IF Text with a JOIN. I am trying to join only certain items when TEXT is found in the first cell for a naming convention sheet. Is this possible?
-
Formula Assistance (SUMIFS, COUNTIFS of CHILDREN)
I'm having difficulty with a few formulas wherein I'm attempting to SUM and COUNT only the CHILD rows so as to not duplicate amounts or counts (ie. need to exclude the Parent Row). The formula below works when the BOLD text is not inserted. The issue is that the potential exists where the sum and/or count will include the…
-
Make Cell Blank if all Columns are "N"
Hi there, Wondering how to amend this formula so that if all the cells are "N", it will return a blank in column "Report Status" =IF(OR([PAR Items]16 = "Y", Proxies16 = "Y", Commissions16 = "Y", Constraints16 = "Y", [APX Reports]16 = "Y", [MRFP/SMA]16 = "Y", Commentary16 = "Y", Attachment16 = "Y", (COUNTIF([PAR…
-
Automation: Request an update but my contacts are not in a contact column
How can I work around this issue. My sheet is populating the "Contacts" via formula. I want to trigger automated update requests but am running into issues since I'm unable to convert the column type to "contact" since it appears that Smartsheet doesn't allow this functionality. Anyone have any ideas how I can work around…
-
RGB Balls IF Function on 4 Colours Rules
Hello everyone, sorry if my grammar is bad. I am Chilean and I recently use Smartsheet, I have learned a lot in a short time. Now I need to solve this formula. Grey = IF Stock Column is “ “ (empty) Red = IF Stock Column is “0” Yellow = IF Stock Column <= Critico Column Green = IF Stock > Critico Column Could you give me a…
-
List of all ranges defined for a sheet
Hi Folks, We have been using a lot of cross sheet links and need to clean things up. Is there a way to see all the named ranges used to access data in a sheet? In other words, show all the ranges and thus the sheets, that are using data from the current sheet? Thanks!
-
RGB Balls Format
rgb balls format I have not been able to set the "status" column to show the RGB balls after programming an IF formula as I show it in the attached images. As you can see the column is edited as Status RGB but the result is delivered in text and not in color balls. I appreciate your prompt help
-
Do Not Apply Formula IF Field Is Blank
I am trying to calculate a variance by subtracting two columns but only if one of them is not blank. I'm having trouble getting the ISBLANK condition to work. My current formula is =[Budgeted Total]4 - [Amount Spent]4 but I only want to apply that formula if Amount Spent is not blank. Any suggestions would be very much…
-
Countif "#INVALID OPERATION"
Hi Im trying to count all "#INVALID OPERATION" in order to catch if someone has enter an invalid character etc in a cell which needs to be added up. I have tried multiple things without success. The following is using the New "contains" function which returns a larger count than it should. =COUNTIF({O_Eq_Total_Hrs},…
-
Sumifs with 2 conditions from same column
I am having trouble creating a formula with 2 conditions. I currently have formulas in a Spend summary sheet that only have one condition but I need to add a 2nd condition. Here is what I have for 1 condition: =SUMIFS({Team DD - Budget - FY19-FY20- Amount}, {Team DD - Budget - FY19-FY20- Requester Team}, "Computing", {Team…