Hi team, I'm trying to add X months from the yellow column to a date and get the result. for ex: 01/01/2025 + 12 Months = 01/01/2026. Is there any way to do so? Thanks in advance!
Hello, community! I have a question. I'm using the "IF" formula to calculate a percentage based on the status in the "status" column. now, I'm trying to calculate the average of those rows, but I get …
Hi everyone, I’m hoping to get some help from the community. Is there a way to automatically group rows in a parent-child format? For example: Parent A Child A Child A Parent B Child B Child B Parent …
Hi guys, I'm trying to copy rows from 3 sheets to another, whenever I'm copying rows from the third sheet its duplicating one of the columns at the end even when all columns in all the sheets are in t…
Hello Team, I have the following data to work on: 22-123 22-456 22-789 23-123 23-456 23-789 24-123 24-456 24-789 Where the first 22-, 23- and 24- represent 2022, 2023, 2024. I'm trying to use the "COU…
Hi guys, I'm working with the following formula: =IF(MONTH([Start Date]@row) = 2, "February", IF(MONTH([Start Date]@row) = 1, "January", IF(MONTH([Start Date]@row) = 3, "March", IF(MONTH([Start Date]@…