Excel Auto Lead ID and Due Date Formulas Not Working

Hi,

I’ve spent several hours trying to resolve two issues in my Excel sheet.

I have a workbook with a separate tab where I created 7 fields. I successfully set up all named ranges, and the setup tab is working fine. I also saved them all in Name Manager, as I plan to use them as dropdowns in a second tab.

Here’s the problem:

1. AUTO LEAD ID (Column A): 

I’m trying to use the formula =IF(B2<>"", ROW()-1, "") so that when I enter a company name in Column B, Column A (Lead ID) automatically populates with 1, 2, 3, 4, etc. However, the formula only returns 0, no matter what I try.

2. Due Date (Column H): 

I’m using =IF(G2<>"", G2+7, "") because I want the due date to automatically update as 7 days after the date in Column G. But this doesn’t seem to work either.

I’ve tried 3 different AI tools to figure out what’s wrong, but I’m still stuck.

Could someone please help me understand what I’m doing wrong?

Thank you so much!