4

Hi,

I'd like a formula to calculate the below

SUM the leave days Request(Column Number of Days) against the employee(Name Column) if Approved(Manager Column) and Approved(EXCO Column). If either one of them are not approved then don't SUM the leave days.

This is what i have so far but cant seem to

2

Hi Smart Sheet Community!

 

I am applying a formula to a cell in our project schedule sheets that I found in a couple posts to grab the MAX value of the Modified (Date) column:

 

=MAX(Modified:Modified) + ""

 

My colleagues and I will be linking the cell with this formula from our project schedule

1

I am running a formula to calculate the days between a start date and today(), if the number is less than 25 then it inserts today's date in a cell.  That cell is then used to trigger an email to a user for action.

If the start date is in the past the calculated days between is a negative.  I want

2

I'm new to SS. This is my first project. I have an audit process I am building for a customer. There are 5 separate forms needed for the audit process. I originally had all 5 forms feeding the same sheet but with over 100+ columns for each audit, I went crazy scrolling left to right looking for the