new column formula
2 Topics
subtracting 100 from each value in another column
i have % increase in one column eg 60%, 80% for various organisations and i want to show the remainder eg 40% and 20% in another so i can show stacked bar charts etc how do i create a column which deducts 100 from each percentage i tried something like % remaing = 100 - % increase but that didn't work Any help greatly appreciatedSolved1KViews1like3Comments
Formula for a column to identify dates that are within 180 days from TODAY
I want to create a column that returns if a project will exprire within 180 days and I am not sure if I also need to account for it is expired or if it will fall from the calculation if it is or not. Would I need "Expired", "Nearing Expiration", "Safe from Expiration" If the permit start date is within 180 days from TODAY and the construction start date is blank it is "Nearing Expiration." If the permit start date has passed (less than TODAY) and the construction start date is blank it is "expired." If the permit start date more than 180 days from TODAY, it is "Safe from Expiration." Can I do this all on one column or do I have to add a column to calculate 180 days from TODAY as well? Permit Start Date Construction Start Date Do I need a column to calcualte 180 days from Today? Expired, Nearing Expiration, Safe from Expiration 6/24/2023 Expired 6/6/2025 Safe from Expiration 5/3/2024 4/1/2024 Safe from Expiration 7/15/2024 Nearing ExpirationSolved1.5KViews0likes3Comments