-
#DivideByZero error
I am trying to use this formula so I dont get the #DivideByZero error but it is giving me this pop up, what is wrong with my syntax? =IFERROR([% Comp.]@row/HTD@row),0) I get this pop up Thanks
-
How can i do a unique Project manager formula in my sheet summary
How can i do a unique Project manager formula in my sheet summary to show unique people working on projects as people work on multiple proejcts but i want to show total unique people
-
Is there a way to use the =PARENT() formula to copy the hyperlink and display text to the child row?
-
Count/Count If Formula
I have a sheet with a date column and another column with a number in each cell (e.g. number of tasks for the particular day/date) - see screenshot. I have another sheet where I would like to count the number in the number of tasks column, but only if they are within the next 30 days. Can't work if this is a COUNTIF(S),…
-
Need an autofill number
Hi, 1) I need a formula, which can fill number automatically Ex: series of num 1,2,3..... if i select a cell next number should come automatically!!! 2) Two coloumns A & b, If I select a cell in colounm A , automatically another cell should autofill in column B. EX: Green, Blue, Red-----Coloumn A 8h, 10h, 24h-------…
-
3 years of data, twice a year
I'm not sure this is even possible, but we want to display 3 years of data at year-end and then at mid-year. So, for the current data, we want the following: Dataset 1 = 7/1/2017-6/30/2020, Dataset 2 = 1/1/2018-12/31/2020. Ideally, this would be rolling, but if we have to manually update, that's fine too - I'm just not…
-
formula for status within last 365 days
I am trying to figure out a formula to use the status (red, green dots) to show if the document is within the last 365 days based on a last revision column. Trying to track program document review. So if the last review column is within 365 then a green dot, if greater than a red dot. Hope this makes sense. Any help would…
-
Does time of day factor in for "Auto-Number/System - Modified" Column filters?
Hello Smart Friends! Im using the Auto System modified column but Im getting all kinds of wonky results when I filter. Ive tried using greater than, greater than equal too, is between, is in the past (days) etc and I keep getting all kinds of off results. I have 89 rows, 41 modified on 1/13, 6 on 1/14, and 19 on 1/15.…
-
Using Index/Match for multiple criteria, if NO MATCH, how to return the remaining value instead?
Hi All, I have a pretty robust INDEX/MATCH formula set up. It pretty much sums up values from 4 different smartsheets into a master one. =INDEX({GB_WN1}, MATCH($Projects@row, {GB_PROJ}, 0)) + INDEX({AN_WN1}, MATCH($Projects@row, {AN_PROJ}, 0)) + INDEX({GS_WN1}, MATCH($Projects@row, {GS_PROJ}, 0)) + INDEX({AD_WN1},…
-
I am trying to use the Red, Yellow, Green balls for days.
This is the formula that I am using but its not populating the red, yellow, or green balls. Can someone please assist? =IF([End Date]@row = "<16 days", "Red", IF([End Date]@row ="<32 days", "Green", IF([End Date]@row= "<32 days, >16 days, "Yellow")))