 # Lisi’s Profile

points
131  Is there a way to set up an alert on a sheet for when it is nearing the 5000-row limit?

Thanks! Hello,

I have a date range:

Date Range Start & Date Range End, and I want to flag it if the "Actual Completion Date" is before the Date Range Start OR if the "Actual Completion Date" is after the Date Range End.

Can anyone help?

I've tried:

=IF([Actual Completion Date]@row > [Date Range How can I lock details in the calendar app, so users can't change the data but only view it? Hello,

I have this formula:

=IF(AND([Completion Date]@row = "", [Date Range End]@row < TODAY()), "Past Due", "ALL DONE")

I've tried a few things but I keep getting invalid operation, and I'm sure it's something foolish and easy but I can't seem to figure it out.

Tahnk you- Hello,

I have this formula to add 10 days to a date:

=[Date1]@row + 10

Then I have this formula to leave blank if there is no date:

=IF(ISBLANK([Date1]@row), "")

I need to put them together so if there is a blank the cell stays blank but if not then it needs to add 10 days to the date in Hello!

I have this formula that works great:

=DATE(YEAR([Completion Date]3), (MONTH([Completion Date]3) + 3), (DAY([Completion Date]3)))

But if my date in "[Completion Date]3" is blank it throws off my whole formula. What can I add so it stays blank if I have no date in "[Completion Date]3".

THANK Hello everyone,

I have a Completion Date of 1/08/2019 and I need the next cell to be 1/29/2019 (which is ten days before 2/8/2019) and the third cell to be 2/18/2019 (which is ten days after 2/8/2019). I've tried every which way I could think of to get this to work. Any ideas?

THANK YOU! Hello everyone,

I am currently using this:

=IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 >= Completion4, "Green", IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 < Completion4, "Red"))))

Which is working but I try to add this:

IF(ISBLANK(Completion3), IF(NOT(ISBLANK(Supervisor4)), "Yellow" Hello!

I'm trying to use this if statement:

=IF(OR(67:67 = "R13"), "500", "")

But it's not working when I want it to check the whole row (67 through 67) for R13. Is there another way for me to do this statement?

Thank Hello,

I have a drop-down menu with a few selections and I want the next cell over to have a text based on what is selected from the drop-down menu. Can this be done?

So on cell B3 I selected 5, and I want the word Tom to populate on cell B4 based on that selection.

Thank