-
Payroll Breakup
Hello, I have pay dates on the 15th and the last day each month. A person may be contracted for say 21 days and that pay needs to be parsed out depending on what days that employee worked in that time period. I am having a hard time coming up with an equation for each pay-period cell. Pay, 1/15, 1/31, 2/15....
-
Manpower Tracking with Projects
I am trying to set up a way to track manpower 50+ people plus projects that are ongoing. 2 separate sheets are fine - 1 project summary and 1 manpower. How can i set it up, that i can see who is available, when workers will be on vacation and it will notify is someone is booked for one project so i can't double book them.…
-
How to total quantity based on similar name in column
I am trying to total points based on the persons name. Basically one column has the names, some of them duplicates. Another Column has points. I need a third column for total points at the end that looks at the names, finds those that are the same and totals the points for that person in the total points column. I have…
-
Automate RYG balls using two colums with IF/OR & IF/AND
I have successfully automated the RYG balls to show a different color as we get closer to a due date, and then show "OVERDUE" when the due date has passed (Urgency). (Days1 is a hidden column that counts the difference between today's date and the due date) Here is the successful formula: =IF(Days1 >= 7, "Green",…
-
Employee Relations tracker
Does anyone have an HR employee relations tracker template that works for them?
-
Links do not work when exported from Smartsheet to Excel
hi, as a part of knowledge migration project in our company, we're storing links to the documents in a tracker on Smartsheet. When opened from smartsheet the links work properly. Unfortunately, when I export the tracker to excel - I am not able to open any of them. Could you advice what could go wrong? Thank you!
-
Calendar View Conditional Formatting
I know how to set conditional formatting to the row for the calendar view. However, I want to format more than just the taskbar color. Is there a way for the font, bold, and underline to also transfer to the calendar view? I am attempting to differentiate two tasks by font, etc. with the same task bar color.
-
UK Contact - Issue with account
Hi, does anyone have a contact number in the UK that works? my account & my whole company is locked out & asked to upgrade when we already have.... this is very urgent!!!
-
Need help with date formula
I am trying to create a line chart widget. The chart would display the date an incident or incidents were reported on the X axis. The y axis would display the number of incidents scale. The widget would report the incidents per the last 90 days. Only the date an incident(s) was reported would display. in the chart.…
-
Upcoming Birthday Report
I would like to include a Report Widget that shows upcoming birthdays, but it doesn't seem possible to only pull data according to month and date (whenever I use the date column, it automatically adds the year -- 2018, in this case). Is there anyway that I can pull data for upcoming birthdays w/o relying on the year they…
