-
Template of % of Job Duties assigned, not based on "completed".
Is there a template I can enter staff's job duties to calculate the % of time? Example: Parent would be Office with child of "accounts payable", "mail", "conferences". I would like to enter the % of each child and then have parent be 100%. There would not be a "Completed" % column nor start/end date columns. Thanks.
-
Add Years to a Date
If Term_Effective_Date = 12/07/15 and Terms_In_Year = 3 Years. What is the formula to calcuate the New Date? I need to add 3 years to 12/07/15. =DATE(YEAR(Term_Effecitve_Date2) + [Terms_In _Year]2, MONTH(Term_Effecitve_Date2), DAY(Term_Effecitve_Date2)) I am getting #NUMBER EXPECTED as an error. Thank you for helping!
-
"Processing" Today date in date range.
Good day all, I am collecting information via a webform and need some assistance with the reporting side of things. On the webform i am asking among other things to provide me with a startdate and a finishdate. My aim is to have automated reporting in the backend that will check if date Today is in range of the user…
-
Contact List - Assigned to - automatic alert?
Hi guys, Is there a way to automatically 'alert' someone if they are 'assigned to' a task using a contact list column? Would love to hear a workaround if you have found one. Cheers
-
Available Staff for Project
Hello, I wanted to see if anyone had a suggestion how to handle determining what staff is available for a new project when it comes in. -We have a set list of staff that is available to work on a project * -Staff would not ever work on two projects at the same time * -We have a column that has a start date/end date for all…
-
Feature Request: Row Summary Documents
Our business utilizes Smartsheet in so many ways. One feature that continually wish Smartsheet had is what I call a "Row Summary Document". This feature would essentially mimic the Form builder already contained in Smartsheet, however it would be in reverse. The form would actually be populated based on an already…
-
Employee Anniversaries
We use Smartsheet for a number of different departments, HR being one of them. I'm wondering if there's a way to conditionally format a "hire date" cell to change colour when an employee anniversary is approaching? There is currently an option to conditionally format for a date that is a certian amount of days in the…
-
Create an update request for a single row, and send to an email listed in that row ?
I have a contact list with 500 rows, one for each employee, that requires constant updating as staffing changes. Is it possible to create an update request for a single row, and have that request go out only to an email address listed in the row, permitting each user to view and update only their own information in one row…
-
SmartSheet Reports have limitations that make them useless for business
We recently learned the hard way that there is a limit to how many sheets a report can access! We use the report feature to create individual task lists throughout our company. Each task list searches all sheets for names in an Assigned To column and refines the search looking for a value of "Needs Action" in the Status…
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
