-
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?
-
Smartsheet Development progress update?
Hi Travis and colleagues, great comunity forum, very impressed! Can we have an update on when we will see hours and minutes added to project plans, I seem to recall this was planned for the Spring this year? Also Gantt on Reports? We have clients waiting for these features. Thanks RichardR
-
Volunteer Management
My organization has a large event in which we use 250~300 volunteers in the lead up to and day of and we've been underwhelmed with volunteer management tools on the market. We've managed much of our volunteer management over the years via Excel which implies smartsheet is a viable solution that allows us to manage the…
-
Drop down box on a webform
Hi there I have created a dropdown box on a webform on smartsheet. Firstly, does anyone know how to edit the drop down list once created? Secondly, I have noticed that completed answers on the webform are not feeding back to a master sheet if the answers were in a dropdown list. Any suggestions would be much appreciated.…
