-
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…
-
Could somebody please help with formulas and reports
I have created an action date column on all my spreadsheets, I would like this populated by default with today's date. I would then like a report running in the background letting me know if any lines become overdue i.e. in the past - I plan to display this on a large computer screen visible by all users If anyone can…
-
Counting number of different children in a section.
I would like to count different children only once in a smartsheet section. For example: Parent row: number of entities Row 1 : "Joe Montana" Row 2 : "Dwight Clark" Row 3 : "Joe Montana" Row 4 : "Jerry Rice" Row 5 : "Joe Montana" The number of entities should return 3. Thanks for your help!!! Steve
-
Formula Help Needed
Hi everyone, Need some help. I'm sure this is a simple formula ... but I'm not Excel (or Smartsheets) savvy enough to figure it out. I have a DATE column, and I have a FLAG column. If the date entered in the DATE column is more than 7 days in the past, I want the FLAG to appear in the flag column. If the DATE entered is…
-
Dropdown list creation from existing columns
I have a database of our company standard operating procedures and I would like to have a webform which allows all of our staff to recommend a revision to a specific SOP. I think I would like to create a dropdown list from an existing column, but it looks like I'd have to type them all in individually to create the list.…
-
Implementing multiple dates in annual plan
Hello, My company is considering Smartsheet so I signed up for a free trial to just try out implementing our Annual plan, we have it in excel today. But am having a hard time adding multiple dates to each row, where each row is a persons annual plan and shows an overview over important weeks through the year. Se screenshot…
-
How to Insert Photo into each column
Hi, Is there any auto function for me to insert one photo per column? I have 92 photos, I need to insert each of the photo into individual column, and it is not an hidden attachment. Is there any programme way to auto this action? Thanks Cheers Quece
-
Full Version
Hi As a compnay (Connect 4) we are using the trial version but are very interested in upgrading to the full version, we would like to discuss what the software can deliver and potential training options. Please could someong contact me via phone or email to discuss, 01279401883 / james@connect4recruitment.com Many thanks,…
-
Capacity Planning
I have effectively put several project plans in place at work. We have summary reports by assignee working really well for updating multiple projects from one report. The next step is calculating how much work we can take in with the resources we have and planning how much extra resources may be needed in the future with…
