-
Conditional Formatting Based on Date / Number of Days
I have an sheet to track my employees. One of the columns is "Last Pay Raise Date". I would like to highlight a row when the number of days since last pay riase is greater then 180 days or something along those lines. Is that possible?
-
Sheet scalability
I have a sheet that I built for year-end performance reviews. The sheet is designed for one person. My company has 50+ employees and it would be great if I can run some sort of macro/app that would take the sheet and replicate it 50 times with each sheet adding a new name from a contact list. Any ideas? Thanks Ian
-
Web Form Layout
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
-
Hospitality Industry (Restaurants)
Is anyone using Smartsheet for their restaurant clients? My thought is to setup a wordspace run everything from new employee forms to inventory counts.
-
Data shuffled after I save
Hello all, I have a sheet shared with 7 people. Almost everytime I save there are multiple rows that are randomly shuffled into different spots on the sheet. I have no formulas or macros... I thought I would throw this out to the community, any ideas?
-
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…