Formulas
Discussion List
-
Why are Round function irregularly displayed in dashboardIn Formulas and FunctionsWhen I use a Metric widget in a dashboard, add data (Rounded) from a Grid is sometimes displays the rounded numbers, but the next, without modifications, it doesn´t.Answered - Pending Review 12 views 9 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Collecting Dates in a Reoccurring ApprovalIn Formulas and FunctionsI have a sheet that needs to be reviewed and approved by multiple individuals on a regular reoccurring basis. I have already set up the workflow for this to happen but I will need to keep a list of the dates they were previously approved. …Answered - Pending Review 2 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Countif, Collect, indexIn Formulas and FunctionsI'm trying to count all installations for a site from the master grid sheet to a new grid sheet. The formula I created only brings back two records for each site. =COUNT(INDEX(COLLECT({**Master Grid "installed" column** - Store I…Answered - Pending Review 14 views 1 comment 0 points Most recent by Kimberly Loveless Formulas and Functions
-
Sum if unique names onlyIn Formulas and FunctionsHi there, I have a rollup sheet that adds the amounts if the names are unique. I get the names with a vlookup formula to get them from the source file. The source file has the names entered multiple times but their amounts are the same. I …Answered - Pending Review 13 views 2 comments 0 points Most recent by Cesar Perez Formulas and Functions
-
Formula with range that goes from a certain row to whatever the current bottom row isIn Formulas and FunctionsMy formula: =AVG(COLLECT(IIQ28:IIQ99, [SE Manager]28:[SE Manager]34, "John Lennon")) First, I cannot use the entire column. There is data in rows 1-27 that can not be applied to my average. I want the range to go all the way to t…
-
Continuously evolving Sum formulaIn Formulas and FunctionsIs it possible to create a formula or workflow that would move/update our "90 Day total" column as new months come and go? I've attached what we are currently working with. The 90 Day Total is just a sum formula for each Jun Jul …Answered - Pending Review 12 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Return unique values while ignoring blanks.In Formulas and FunctionsHello! I'm trying to find a function similar to vlookup or index that will return a unique value where there are duplicate search values. In this example, individuals book a desk on a given date. Since form submissions create a new row, th…
-
I want to return a negative number as this sheet will be used for our accounts payable team.In Formulas and FunctionsI'm using a simple Sum formula. I want to display this as a negative. conditional formatting to change the color will not work. It needs to either be -$192,000 or (192,000) =SUM([2021 Total]1:[2021 Total]46) = 192,000 I've tried sumIF wit…
-
Formula for replacing specific charactersIn Formulas and FunctionsHi everyone! I am struggling with the formula language for this. So in Column 1 I have the file names with their file extensions. In column 2 I'd like a list of the filenames WITHOUT the extensions (see the top row) Is there a way to write…
-
Formula for At Risk FlagIn Formulas and FunctionsHi Experts, I am using the following formula to turn the At Risk flag red when the condition is true. But I am getting a #UNPARSEABLE error. The formula is trying to say: If either of these conditions is true, I want to turn the At Risk fl…
