•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
I am having a issue with a previously working formula
Our take
If you're encountering issues with a previously functional Excel formula on SharePoint, you're not alone. This situation can be frustrating, especially when your formula for autostamping date and time has worked seamlessly for over a year. Despite confirming that your devices are synced, calculations are set to automatic, and formatting is correct, the formula is now defaulting to unexpected values. Let’s explore potential solutions together to restore your formula’s functionality and ensure your inspection tracking remains accurate and efficient.
Hi,
I use Excel primarily on SharePoint to track inspections on a production floor. I have used the same formula for over a year: =IFS(D38=FALSE,"",E38="",NOW(),TRUE,E38).
Essentially, when the field is checked off, it autostamps it with the time and date. (See Picture). Since Friday, however, the time and date defaults to what is shown in the picture.
Troubleshooting I have tried is confirming that all devices using this sheet are time-synced, up to date, and restarted. I have confirmed that the calculation options are set to automatic and that the formatting is correct for both time and date. I have re-typed the formula as well. I am at a loss, as it was a perfectly functional formula up until Friday.
[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]
- Conditional formatting date help neededI've been trying to use conditional formatting to help automate my work spreadsheet and the date formulas truly escape me. I feel like TODAY is a meany who likes to stick their tongue out at you and point for being stupid XD. This is a spreadsheet with a schedule on it. I am trying to get it to automatically grey out the text when the date passes so I can sort and filter by color and always keep the next upcoming appointment slot be top of the list, while still keeping the data in this sheet because another sheet refers to it via XLOOKUP. https://preview.redd.it/z1jqata8w6xg1.png?width=364&format=png&auto=webp&s=d49f71c8de80c402de1af923fc87e3371d606cc8 Here's the formula I'm using =AND($B$2<TODAY(), $D$2<> "") Column D is client names, for privacy purposes I didn't copy that. They end at D11, if it matters. I'm not sure why excel is treating the dates in May as if they are less than today, when they're not. Does anyone have any ideas? submitted by /u/tashykat [link] [comments]
- Excel Auto Lead ID and Due Date Formulas Not WorkingHi, 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! submitted by /u/Sad_Abbreviations_62 [link] [comments]
Tagged with
#real-time data collaboration#real-time collaboration#Excel alternatives for data analysis#AI formula generation techniques#formula generator#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#rows.com#financial modeling with spreadsheets#Excel#time stamp#formula#SharePoint#date#troubleshooting#IFS#calculation options#autostamp