New answers tagged

0

This is now possible by inserting a formula instead of a static number into the box for min/mid/max amount.


0

Google Sheets has a built-in feature allows to set formatting rules, it's called Conditional Formatting, but it doesn't has a way to set the comparison of the current value with an old value. One alternative is to use Google Apps Script, another is to use an add-on. Using Google Apps Script If you decide to use Google Apps Script, you could use an on ...


0

I think I solved the problem: IF is not needed. I removed it and the new formula worked: =MATCH(A1,INDIRECT("'Master'!$A$1:$A$60"),0)


1

If you're trying to SUM() a column based on criteria, then SUMIF() or SUMIFS() would get you what you want. In this example you could use SUMIFS() =SUMIFS(P:P, A:A, "PG", F, "Indexed") - this gives you a SUM of values in P where Column A = "PG" and Column F = "Indexed". You could extend these criteria for as many filters as you need. You'd then change this ...


0

The default values for checkboxes are TRUE and FALSE. If your checkboxes use the default values, the conditional formatting custom formula should look this way: =A4 In the context of the conditional formatting feature of Google Sheets that means apply the conditional formatting when the value of A4 is true. Instead of A4 you should use as reference the ...


0

As Tedinoz said in the comment Start by identifying the relevant date, then calculate the day of the year for that date - use the days function. For example, March 15, 2020 is the 75th day of the leap year. Now calculate the day in the 15-day cycle - calculated manually, this is day 15; use the mod function to express this mathematically - mod(75,15) equals ...


Top 50 recent answers are included