-
If Error Formula for averages
Hello, Is there a way to use IF Error for an average? So if there is no data yet, it displays zero instead of the DividebyZero error? Thanks for the assistance!
-
Remove Link but Keep the data
Hi, Is there to keep the previous data if the Reference if deleted. I have this formula =IF(vlookup(referencetoanotherSheer)=x, True). But if the other Sheet is deleted, I want it to maintain the value instead of showing #REF
-
Mirroring a Grandchild row cell in the Child row cell based off current week
Hey all, I'm relatively new to Smartsheets and am hoping someone can help me out. I promise I've looked everywhere for an answer and I think I'm making this more complicated than it is. Thanks in advance for the guidance! I have a sheet where I'm tracking historical quote metrics by Sales rep and Week. At the suggestion of…
-
COUNTIF on FLAGS at PARENTS level not returning any value (number)
Hi Smart Community, I am trying to Sum my CHILDREN() Countif but it is not giving any value. All my sub-children is indicated as flag (1 or 0) Example When there is a delay release in a category Bug Fix : it will flagged out RED. On Bug Fix, I did =COUNTIF(CHILDREN()),1)+"" This seems to work fine and return with 2 (which…
-
One person has multiple jobs on one day
Hi, I'm looking to adjust my sheet based on one person having multiple jobs in one day. What I'd like to do it have it be that each person has only one job per day. Ideally, SS would be able to look at all other jobs this person is assigned to and adjust the start dates of other jobs based on available slack time (away…
-
Default Background Color
Greetings I some how got the background of one of my smartsheets to appear gray whenever I create a new column and when I pull a report and display the Sheet Name (system column) it too appears to be gray. I have doubled checked the conditional formatting and I am not using any gray colors. I have all my other columns…
-
Reproducible Hyperlinks
I'm compiling a hyperlink section to include at the top of project sheets, a little more than a dozen in total. This collection creates my tabbed "Excel report". It will allow end users to navigate to the tabs/sheets they need. I can then save them in their feature (finance, schedule, risk, invoices, cash flow, etc)…
-
Updating a Date Column after another cell is updated.
I am trying to have a Date Column update with today's date when a single select option is chosen. I don't want to use the system update date column because that will get updated whenever any cell is selected. For example: I have a single selection column with several options: Estimating Complete, Quote Sent, and Sale. I…
-
Use Wildcards in an INDEX MATCH formula
Hi everyone, I need to use INDEX MATCH formula to get a DS# with a CNDT# in another report. The easy formula would be: =INDEX({DS Report Range 2}, MATCH([CNDT Number]1, {DS Report Range 3}, 0)), "") but the thing is that sometimes there are more than one CNDT#'s in a single cell. Since INDEX MATCH looks for the exact match…
-
RYGB Symbols Average Formula
I currently having issues with creating formula that gets the average of 4 cells that have the option of 4 different symbols (Red,Yellow,Green,Blue). The goal is to show the average of the four cell symbol's in one here is what I have so far. =IF(COUNTIF([PW Goal]3, [BB Goal]3, [JQ Goal]3, [MC Goal]3, "Red")) = 4, "Red",…
