-
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?
-
Flexibly managing resources for assignment - by logical project groups
a - We manage a constantly evolving list of projects, with each project being managed by 1-3 Smartsheet Users (our PMs), and tasks being assigned to one of the 15-45 resources (people, -vendors, managers in the customer's company (not users). b - The list of contacts is unique to each project c - The 1-3 PMs need to be…
-
Can you add an item in calendar view?
Can you add items in calendar view, or only edit?