-
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…
-
"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.
