Trending in Formulas and Functions
-
Imbedded If Statements
I'm trying to use a formula (below) that will: 1)If a deviation was Approved, it is past its End Date...if Past End Date return "Expired", if not return "Active" 2)If it was never Approved, return "Rejected"......no need to evaluate if it is past its End Date. My formula is returning Rejected only. =IF([Approval…
-
Sheet Summary Field Formula to Summarize Expenses in a Column by Year
I have a sheet that includes a column of net costs with a Year column. I want to create a sheet summary field with a formula that calculates the total net costs for a specific year (e.g., 2023). I tried the following =SUMIFS(Revenue_Column, Year_Column, Year_Value) but kept getting an error, and I don't think it's…
-
Determining AM or PM Shift Question
I there a way to determine if an employee works an AM or PM shift based on the following text? There are appox. 67 different schedules. 4/40 Sunday - Wednesday 8:00 PM - 6:30 AM 30 Min Lunch 4/40 Sunday - Wednesday 6:00 AM - 4:30 PM 30 Min Lunch There are appox. 67 different schedules. Thank you! Ron
