Welcome!

Help: Status update from a reference sheet with formula

Dear,

Can anyone please help me, I am trying to create a formula to generate a status update based on end date from a reference sheet (name: Cloud).

=IF({Cloud Range 2},"Complete" <> 1, IF(TODAY() - [End Date] > 0, "Red", IF(TODAY() - [End Date] > -3, "Yellow", "Green"))))"

I have added the header of the sheet I am trying to reference from.

Many thanks in advance.

Thanks lads. I was able to solve it after some try and error!

"Alert Someone" Automation Inconsistently Working
For a couple years now, we have been using the Alert Someone notification when a "Test Status" column is updated to the phrase "Scheduled" from a dropdown. This has typically worked without a problem. In the last couple of weeks some notifications are sending when this condition is met and some are not. I can't figure out…
Why is sort by date not working right?
Hi, For some reason, using sort dates, my report has put January 2027 before any 2026 dates? Conditional formatting it set up to be red if not complete and past date, hence the 2027 row being the only white. Thankyou in advance!! :)
Form did not populate a required field
I have a form and the first question is a required field. However, I have five entries (out of approximately 400) that have come into the sheet with no data for this required field. Has anyone seen this before? Any clue how this happened? Here's what I've checked: blank space is not an option (form won't let me submit)…