-
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…
-
linking value from parent cell
EDITED: i found the =PARENT function the listed as this in the cell but my cell is turning out blank! =PARENT([Topic & Subsequent Action Items]13) Its recognizing the function as the cell i want to reference is outlined in blue... HELP! the function initially worked when the Meeting date row was a child of the "upcoming…
-
Return sum of one column if today's date is between A and B, etc
Hi guys, I can get the following formula to work without issue: =IF(TODAY() = DATE(2019, 8, 9), SUM([2019 Aug]:[2019 Aug])) What I can't do is update the logical expression to be if today's date is between Aug 1 and Aug 31. Essentially I want a self-updating formula that will always show me the sum of the appropriate…