-
New reactivation policy for deactivated users
Hello! I am trying to figure out how/why this new policy was started and how it makes sense. When we have users that are eligible for rehire, we deactivate them and then reactivate them when they are rehired because we use the same AD stuff (even if it's been a couple years). No issue, we're good to go. Now, the policy has…
-
Notifications appearing in Smartsheet, but not receiving notification email
Many on my team are receiving Smartsheet notifications in their Smartsheet alerts, but not receiving the notification email. Settings were checked and all boxes are checked to receive emails for any/all notifications. Can't figure out what else may be the hurdle here? Thank you!
-
Automations
Looking to see if anyone else has experienced a similar problem or might have some insight into why the below isn't working right for the team I'm working with. We've setup a grants tracking database that will send automated alerts for various things including if an end date has passed and the grant manager hasn't updated…
-
Users Submitting From Excel to Existing Sheet
Goal: I'm looking for a way for employees to copy/paste or upload new rows of data from Excel into Smartsheet without seeing the full sheet and ideally without needing a Smartsheet account. Project Overview: I'm building an expense report system where employees submit weekly expenses for review and approval. Currently,…
-
Backups Not Extracting
I'm trying to extract my Smartsheet backups, and I'm running into errors. It looks like all of the files that were extracted on or before 8/18 are fine, but the ones I have starting 8/25 aren't working. A couple of my coworkers are trying to redownload things on their end (different workspaces), and we're all getting…
-
Resource Management: Regional Public Holidays
Official Public Holidays in Resource Management are not helpful when team members work across different states or countries. The ability to define Public Holidays based on team member location (automatically would be best) is needed. The Location of each team member is defined in their profile. Use this to update the…
-
Add new rows/line items in reports
Bi-directional information is what makes reports awesome. Being able to add new rows directly within a report would be helpful if I only want some people working in a certain report so that they only see certain information. They could then work directly within that report and not have to bother with other reports/sheets.
-
Help with INDEX/DISTINCT Not Working!!
I have the following formula: =IFERROR(IF(Auto@row = 0, "COMPANY NAME", INDEX(DISTINCT({Company Name}), [Row ID]@row )), "") Problem is - it has stopped working. It pulled out the first 115 vendors out of 425 items, and then stopped. Is there a maximum number of distinct items it will pull into a list? I do not see any…
-
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…
-
Track changes in a data element over time
A customer of mine would like to be able to see what rows in a project plan have changed their task status over a given period - probably a week. A scenario would be in preparation for a weekly team update meeting, the customer would like to be able to see a summary of what has changed from 'Red' to 'Yellow' or 'Green' and…