-
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?
-
Timesheets
My firm uses Smartsheet for timesheets and client billing. There are now 22 people filling in individual timesheets. There is a Client Name column with a dropdown box with all the client names, probably about 100 now. Monthly, I manually go into all 22 timesheets and update that dropdown box with new client names. This…
-
keeping answers on different students together for different teachers
I am sending out a web form ~ having different teachers fill it out for different students. Can I keep all the answers together for the 50 different teacher specifically?
