Paul Newcome’s Profile

Community member since April 2018




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


Hey, I have set up a dashboard with a hyperlink to another Smartsheet item (a report). When I click on it the report opens in the same window, which is what I want it to do.

However, when another user clicks on the link it opens a whole new window. This happens regardless of whether the user is


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


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