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

Dear Community,

I am trying to SUMIF accross all Children and Grand Children but unfortunately retrieving an #UNPARSEABLE value.

Here are the formulas I have been trying:

SUMIF(\$[Payment Status]5:\$[Payment Status]50), "Received", [2019 Wk 02]5:[2019 Wk 02]50))

=> result to #UNPARSEABLE

I trying to use to create a sheet that I will use to determine the status by comparing 2 status and then give an answer the e.g. If the status1 is low and status 2 is low the actual status should be low, I used the following IF/AND Statement and it worked fine:

=IF(AND([Status1]3 = "Low"; [Status2]3

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

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

Is it going to cause any issues if I nest (indent a couple levels) data inside a sub-category, inside of a main category? (see attached

Please share the formula that will auto populate the current date or "Todays Date" in the Completion Date column when the checkbox is populated in the "Done"

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

In an effort to further automate my sheet, I worked out a piece of code that will update the content of a status cell, based on two other cells, the Task Hours Complete/Task Total Hours. I did it this way because I incorporated a "%" sign in my "% Task Complete" column, and that non-numerical

In Sheet 2, I want to JOIN and COLLECT a group of values from Sheet 1, separated by a comma. I have this figured out:

=JOIN(COLLECT({AutomatedCourseCopy-CRN}, {AutomatedCourseCopy-CRN}, <>"", {AutomatedCourseCopy-UseinBCC}, <>"", {AutomatedCourseCopy-College}, CRN1), ", ") + ","

I have a set of