•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Excel Auto Lead ID and Due Date Formulas Not Working
Our take
In your Excel workbook, you're encountering challenges with the Auto Lead ID and Due Date formulas, which are crucial for your data management. The formula for the Lead ID, designed to automatically populate sequentially when a company name is entered, is returning zero instead of the expected numbers. Similarly, the Due Date formula, meant to calculate a date seven days after the specified date, isn’t functioning as intended. Let’s delve into these issues to uncover the root causes and streamline your spreadsheet experience.
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!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Trying to calculate the difference in dates using =IF Formula. I am new to ExcelHi, totally new to excel, trying to apply formulas from a previous excel sheet to another. Hello, I'm very new excel and not very good at it. I work a corporate job and I'm trying to calculate the days between two dates(so if M is 1/1/2026 and O is 1/2/2026 i need the difference in column N). I have a formula from a previous spreadsheet and I keep trying to apply it to the new spreadsheet but it keeps coming back as #VALUE!. I also put the formula in Copilot and I can't forgive the life of me figure out the formula or why its not working. I also need for the whole column with different dates. the formula from a previous spreadsheet is =IF(ISBLANK(E139)" "IF(ISBLANK(T39),TODAY()-E139T139-E139)) Hopefully this makes sense. I'm honestly not great with Excel and trying my best. If someone could help that'd be great. Thankyou so much! EDIT: You all have been wonderful! TY!!! submitted by /u/jensinoutaspace [link] [comments]
- Excel formula automatically rewriting itself??Hi all, this is a really odd problem to run into and I am unsure how to proceed from here. I am currently entering data and I have Excel performing an =SUM(B5:AC5) for my data that is being entered. Because the data entry can go pretty fast sometimes, I would keep entering data past AC5 before I realize what happened. When I look at my SUM column, Excel has flagged my =SUM(B5:AC5) formula with the error below, which is fine and whatever, but it is automatically changing my =SUM(B5:AC5) formula to =SUM(B5:AF5) or something of similar depending on what column I stopped at. Just for reference, data from AD5 to AO5 is being summed up in another column with SUM=(AD5:AO5). Formula error being flagged by Excel I have no idea why it is doing this and I tried to ignore error, but it still automatically rewriting my formula anyways! This worksheet and formula worked smoothly 4 months ago so I don't know what is going on. submitted by /u/WildKhanine [link] [comments]
- What formula should I be using to populate one column’s data automatically based on my entry for another column?Hi! I need some help here. first off, I’m not allowed to use a v-lookup for this file due to some organisational restrictions, so i’m unable to create a table 2 to facilitate the lookup values. I’m only allowed to use table 1 itself, which is where I have to put in all my values. I have been trying to use index/match instead but can’t see to figure the right formula out. so basically, what I need is for my manual input of data in column J to populate the associated remark in column K. • column J input “NA” = column K input “visit 2” • column J input “nil” = column K input “insufficient blood” • column J input “1” = column K input blank these are the only 3 that I require. let’s say I require it for 30 rows. so my range of rows to populate would be K2:K30 based on the directly adjacent data of J2:J30. how can I do this in formula or automation? thanks in advance! submitted by /u/yanny-jo [link] [comments]
- Sum formula for calculating month occurrences from dates works for everything except for January.I am attempting to automate the calculations of how often each month is recorded in another tab. The formula is working for all the other months, but as I am using this template to calculate values as I enter them, I arbitrarily set the limit to 2000, allowing me not to have to think about changing the formula as I enter new information. Unfortunately, it seems that the blank cells are being coded as "1" https://preview.redd.it/7zte9xn701vg1.png?width=972&format=png&auto=webp&s=ba131bec322f84ce55fa9fdbc35cedfcbeb12d9f I have tried going through the formula and found that all the blank cells are coding themselves as "true" only for the month of January (1). I attempted to add =IF(SHEET2!A3:A2000 = " ", 0, ... to the beginning of the formula, but it just gave me a spill error. I might be getting confused between excel vs. Google Sheets formulas. Thank you! submitted by /u/mentallylost14 [link] [comments]
Tagged with
#Excel compatibility#Excel alternatives for data analysis#Excel alternatives#AI formula generation techniques#financial modeling with spreadsheets#no-code spreadsheet solutions#formula generator#rows.com#self-service analytics tools#business intelligence tools#row zero#collaborative spreadsheet tools#data visualization tools#data analysis tools#Excel#AUTO LEAD ID#Due Date#formula#named ranges#Name Manager