-
formula or workaround...
Hello, I'm trying to build a sheet to use for our onboarding process. It would be nice to have on sheet for all positions. The issue is that all positions do not require the same onboarding activities. I would like to reference the job title / column and have conditions that would have the sheet only display or include the…
-
How do I create the Annual Manager Evaluation Form?
It can be found at this link: https://www.smartsheet.com/free-employee-performance-review-templates I've searched through Templates and don't see it.
-
Best practice of recording occurrences
Hello - apologies if this has been covered elsewhere, I've tried to search for the answer but can't find anything which may work for my purposes. Ultimately, it may not be achievable, but I thought I'd ask: I am creating a group of sheets for a team I work with, and they're dealing with recruitment of individuals (inwards…
-
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…