-
Getting the Top 10 Largest Values
Hello! I was wondering if there is a formula where I can generate a top largest values based on my data. Like for example, I want to get the top 10 largest Man Hour with their Employee Names listed. Looking forward to your responses. Thanks
-
Simple Performance Review Template?
Hi, Anyone that can help? I found the themplate: 'Simple Performance Review Template' on this Smartsheet website: https://www.smartsheet.com/free-employee-performance-review-templates But I can't find the template in the Human Resource category within Smartsheet. Any suggestions? :-) Kristian
-
All videos simple - don't show realty use of training needs
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…
-
Countifs within date ranges
I have - a column containing weekdays, that spans a complete school year. a column containing an assortment of names that re-occur on a random basis. I want to count how many times each name occurs from the start of the date range, but only up and not beyond today. Any help appreciated!
-
Work Spaces
Hi All Is there a way of making folders or other workspaces within a workspace? i have a lot of Reports and sheet and it geting messy Any thought greatly appreacted
-
Locking Cells/Columns in a Report
Hi Smartsheet - I recently created a series of report in smartsheets that pull specific pieces of information for departments so that managers can see their respective things and provide updates. However, unlike a regular sheet, where you can lock certain columns so as to prevent users from being able to edited field, we…
-
Publish Calendar Format - Hyperlinks Lost
Hello, I searched but didn't see an answer to this issue: I maintain a calendar, based off a SmartSheet template, whichI publish to our intranet. In the description field, I would like to include hyperlinks. In grid view, the hyperlinks are active and functional. When I change to calendar view, both for myself or looking…
-
Automate RYG balls when a check box is ticked in one colum only out of three columns
I am trying to create a formula that changes the RYG balls to Green if one box is checked out of three columns. Can anyone help?
-
Combining COUNTIF and COUNT(CHILDREN) formulas
Is there a way to create a single count formula that will return the number of rows using two criteria? I need the number of rows with column A = Abby and column F = MONTH(@cell) = 2
-
how to create a formula that will return the years of service for an Employee
I need a basic formula that will take the employees start date and todays date to calculate years of service?