-
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…
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
Is there a way to have the rows automatically sort ascending by date when new rows are entered?
I have a job board created that jobs are added to and dispatched from the problem is if the jobs are not ented in order by date then I have to manually sort each time. This is a 24/7 process mostly accessed by mobile devices so sort is not an option.
-
How can I summarize people working by hour on a simpe excel sheet?
This might be simple for one of you but it's driving me crazy. Please help. The enclosed pic is part of a simple employee schedule where employee daily hours are entered on a "time in" and "time out" basis. Below the schedule you'll see a breakdown by hours of how many employees are needed for that day (which is entered…
