Login

u/FaithHopeLove821

r/rolltide r/googlesheets
FILM STUDY: How Alabama's Offense Dismantled Mississippi State's Defense | Alabama vs Miss St. Recap
▲ 30 r/rolltide

FILM STUDY: How Alabama's Offense Dismantled Mississippi State's Defense | Alabama vs Miss St. Recap

In summary: OLine took some more souls, and the TEs are going to face charges for assault.

youtube.com
u/FaithHopeLove821 — 10 days ago
▲ 42 r/rolltide

The Saturday Down South staff voted on the all-century college football offense. Alabama has two WRs (Amari Cooper and Devonta Smith) and four Linemen (Andre Smith [OT], Barrett Jones [OG], Landon Dickerson [C], and Cam Robinson [OT]).

instagram.com
u/FaithHopeLove821 — 3 months ago
▲ 2 r/googlesheets

Conditional Formatting Based on Dates

I'm working on a housework spreadsheet. I want to highlight in red the cells in the DATE column where the date has passed two weeks (ie. the date 6/26/26 highlights in red on 7/10/26).

I currently have the cells selected that I want to have the conditional formatting rule applied, with this forumla:
=$C4<=TODAY()-14

When this rule is applied, the cell with the current date is not highlighted in red, and future dates are not highlighted, which is what I want. The problem is that empty cells are highlighted in red as well, which I don't want.

I tried changing the formula to:
=IFERROR(=$C4<=TODAY()-14)

While this keeps the rule active, it doesn't clear the issue: empty cells are still highlighted in red.

The attached screenshot is showing what is currently happening.

u/FaithHopeLove821 — 4 months ago
▲ 3 r/googlesheets

Message Formatting Using AppScript

I'm trying to create a custom popup message for my team when they open a particular sheet. So far, I have this functioning code:

This is what I want the message to look like.

function onOpen ()  {
  var ui = SpreadsheetApp.getUi();
  ui.alert('Be sure to enter the login information for each student. If their password has changed, either before testing days or on a testing day, ensure that change is reflected in Columns E, F, and G. Make note of the instructions in Column H. Verify student passwords before testing. Update the Verification dropdown after password changes.')
}

I want to add text formatting to make the first line look like a title (see attached screenshot). Any help is greatly appreciated.
reddit.com
u/FaithHopeLove821 — 4 months ago