-
Edits to existing recurring report attachments
When making changes to an existing recurring report attachment as an email, I am able to edit aspects like dates and recurrence, but not the distribution list. I have to cancel the recurrence and create a new one. Is there an easy way to update the distribution list for this instead of having to create an entirely new one?
-
How do I create a report from various forms?
Ok, so I have about 17 forms created for various employees in different departments. Each employee is required to fill out this form x amount of times a month. I want to make a report to auto populate that shows how many times employee filled out the form, and I want the report to show the employees percentage of completed…
-
Automating count formula and trend summary
Hello All, I am wondering if there is a way to automate this process. I am trying to get a count of each line item status type at the end of each day. Currently, I am updating a master sheet that has a status column reading either “active” or “not active.” At the end of each day, I am manually totaling the number of active…
-
Formulas Not Pulling
We currently utilize a very large global onboarding smartsheet. When a new hire accepts a position, the onboarding team uses a form to manually add them to the tracker so we can assign out the onboarding tasks and track progress. As part of a business initiative, we also have hidden column to track the amount of time spent…
-
Activity log for certain user
I have noticed on log history that one user has successfully logged in. I have full admin account, can I check his activity since last log in ?
-
Milestone coloring and Multiple Label Options
Can you add these features this year?
-
Not so pretty IF-function (works) but needs makeover
Keeping track on vacation time I need to convert dates to weeks and then again to an overview with checkboxes. In order to get a list of weeks [c_weeks_listed] (later in use with FIND) I have come up with the following IF-formula which works but will become too complex if expanded further. Any ideas for a more powerful…
-
Multiple sorts/countifs of different columns
Hello - new user here! I have a new sheet with ~200 rows with ~25 columns. I have created a form to feed data into the sheet and that is working great. A few of those columns include creator name, department, category, and a few other 'metadata-type' fields. I'm struggling to create summary reports of those 'metadata-type…
-
How to have a report exclude certain items
Hi, I'm trying to build an action item report that only shows approved items that do not meet certain criteria. So in the smartsheet, there is a check box for a document attached and several columns for links to other places. I would like to have the report include only items that are marked as approved (a dropdown column)…
-
Dashboard issues
Hi SS community…. One of the biggest pain points for my team and myself is the space that is wasted on dashboards. When You display reports and Dynamic calendars etc. and the lines reported in the widget do not fill the space at that moment it leaves a ridiculous amount of empty space which for a dashboard does not bode…