Applying Formulas to Entire Columns
I'm new to the community. Our company has adopted SS for projects and we're now looking to expand the use to HR, specifically starting with leave requests.
I've started a leave request sheet based on the template below, with a few adjustments geared toward my company.
So far, this template is a great starting point. Now I want to enhance my template by adding simple formulas to an entire column. The problem I'm coming across is that these formulas don't apply to new rows added via web forms.
For example - see image below:
- I'd like my Total Days Off Request column to auto-calculate the number of days off that an individual is requesting based on the sum of the Vacation Leave | Sick Leave | In-Lieu Leave | Bereavement Leave | Parental Leave | Leave without Pay columns
- Take a look at row two where an individual has requested for Bereavement Leave (3 days) and additional Vacation Leave (2 days), a total of 5 days off requested
- Second, I'd like my Remaining Eligible Vacation Days updated once the Status is changed to Approved by subtracting Current Eligible Vacation Days from Vacation Leave
- I'd like to apply a similar concept to Sick Leave as well
Perhaps you have some tricks up their sleeves or a workaround for my above roadblock?
I'm also open to any suggestions that may have worked for you and your company.