|
About the Formulas and Functions category
|
|
0
|
35
|
March 18, 2020
|
|
Avg if, median if
|
|
12
|
54
|
May 8, 2021
|
|
If contains, then xyz
|
|
12
|
100
|
May 8, 2021
|
|
Product Aggregation
|
|
11
|
47
|
May 8, 2021
|
|
I have a one- or two-digit number that I want to convert to text, retaining the leading zero
|
|
12
|
63
|
May 7, 2021
|
|
"OR" Condition on Filters
|
|
12
|
71
|
May 7, 2021
|
|
Why lead function does not work on my worksheet?
|
|
6
|
43
|
May 7, 2021
|
|
Parameter Date Truncation
|
|
12
|
73
|
May 7, 2021
|
|
How to build a hyperlink with a custom title
|
|
13
|
66
|
May 7, 2021
|
|
Filling in Missing Days per Grouping Level
|
|
12
|
82
|
May 6, 2021
|
|
Adding a Row Count
|
|
12
|
64
|
May 6, 2021
|
|
Counting Values From This Month
|
|
12
|
57
|
May 6, 2021
|
|
How to calculate percentages in a chart or pivot
|
|
5
|
30
|
May 6, 2021
|
|
Find a Quarter based on custom quarter boundaries
|
|
5
|
29
|
May 6, 2021
|
|
How to create a proper timeline chart when there are missing rows
|
|
12
|
63
|
May 5, 2021
|
|
How can I get the nth element of an array?
|
|
0
|
8
|
May 5, 2021
|
|
Change any character to a null
|
|
11
|
52
|
May 5, 2021
|
|
Changing Probability Distribution Into Cumulative
|
|
12
|
50
|
May 5, 2021
|
|
Number() Function Details & Examples:
|
|
7
|
46
|
May 5, 2021
|
|
Only able to use Relative Date filter in UTC
|
|
12
|
48
|
May 5, 2021
|
|
Extracting columns from semi-structured data (variant columns)
|
|
12
|
57
|
May 4, 2021
|
|
Function Used to Find Specific Strings
|
|
12
|
56
|
May 4, 2021
|
|
Tagging relationships between rows
|
|
12
|
48
|
May 4, 2021
|
|
Date() and DateParse()
|
|
10
|
40
|
May 4, 2021
|
|
Fix AWS S3 Access Log Date to be ISO Compliant
|
|
12
|
55
|
May 4, 2021
|
|
Is whitespace the same as a null value
|
|
10
|
46
|
May 3, 2021
|
|
Cohort Analysis
|
|
10
|
62
|
May 3, 2021
|
|
Selecting Nth Value per Grouping
|
|
10
|
41
|
May 3, 2021
|
|
Filtering Out Values With More and Less Characters Than Desired
|
|
10
|
59
|
May 3, 2021
|
|
Formula for Finding Amount of Days Until End of Month
|
|
10
|
49
|
May 3, 2021
|
