Latest activity
-
shamimarita replied to the thread [Solved] Help on creating an excel spreadsheet with formulas on Pro Forma Statements.Hello Zebrabeside, You can follow the same Excel structure shown in the previous reply. The External Financing Needed (EFN) can be... -
shamimarita replied to the thread Time additions dd:hh:mm.Hello Lee, Thanks for sharing the sample. In your sheet, the values in column E are being treated as normal time values (hh:mm:ss), so...
-
LHi. I have a team of people that record jobs onto a system in the format of dd:hh:mm the sheet could be a weeks worth or a days worth...
-
Zzebrabeside replied to the thread [Solved] Help on creating an excel spreadsheet with formulas on Pro Forma Statements.I need I need, please for me!!
-
Zzebrabeside replied to the thread can someone solve this.Most likely some cells in V3:V29 still contain text values or hidden spaces, so SUM skips them even if the format says Number. I’d test...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, Yes, using your spreadsheet as the practical example, the portal value of 652.99 can be matched. In your sheet: Gross...
-
MMaps replied to the thread [Solved] Tax Calculation.Thank you. Can you please use the spreadsheet that I submitted as a practical example for me to understand.
-
Andrewalwin reacted to shamimarita's post in the thread Inventory System on Google Sheets with
Like.
Hello Andrewalwin, Thanks for your helpful input. Yes, I agree. For this type of inventory tracker in Google Sheets, Apps Script is... -
shamimarita replied to the thread [Solved] Tax Calculation.Good morning. Thank you for the clarification, and no problem at all. That makes much more sense now. Since the portal result is...
-
MMaps replied to the thread [Solved] Tax Calculation.Good morning Shamima. Thank you for getting back to me. Yes I agree that it has to do with annualization/proration. The portal uses the...
-
shamimarita replied to the thread [Solved] Tax Calculation.Hello Maps, I checked the workbook you attached. The issue seems to be related to the annualization/proration calculation rather than...
-
MGood day. I made a similar post with Excel Forum on the 11 May 2026 and it has not been solved. Can you assist me with a matching...
-
LLucasFairbairn replied to the thread Inventory System on Google Sheets.yeah this is a solid setup, especially the script for timestamps - formulas really don’t hold up for that
-
shamimarita replied to the thread Inventory System on Google Sheets.Hello Andrewalwin, Thanks for your helpful input. Yes, I agree. For this type of inventory tracker in Google Sheets, Apps Script is...
-
Andrewalwin replied to the thread Inventory System on Google Sheets.You can do this with: Google Sheets timestamp formula/script ARRAYFORMULA for auto-fill Google Apps Script for permanent timestamps...