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


Hi all,

I have currently set up cell linking, however I only want it to cell link once the drop down box has been changed to 'Converted'. As in, we receive a lead and add the data to that lead. Once that lead is 'won' or 'Converted' I change the drop box to show this. Once this is done then I want


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