-
Please add admin ability to force password resets
Forcing the reset of a user's password is critical to the security and efficiency of any user management system. Every other web service I can think of that uses an admin/multi-user structure has such a feature. Here are some examples where a forced password reset would be not only useful but dramatically affect the…
-
How to use a value in AVG that is selected from criteria
Hello! Would like to ask a question regarding AVG and the ability to only pick up a value if a certain condition is meet. Here is what I'm using. =IF({Call Center_Help Desk Data Priority} = "Level 1 - Critical", AVG({Call Center_Help Desk Data Value TTFA})) Objective: To pull in a value to be averaged for all Level 1…
-
Connected MS Teams to Smartsheet with Wrong Login - how to change
I've integrated MS teams with Smartsheet, but accidently used the wrong login (a GMAIL login, not the right smartsheet login I am trying to integrate with MS teams) I've uninstalled Smartsheet in MS Teams, and tried to re-add, but no longer get the option to login; and cannot find any option/place to change the login. How…
-
Intranet in Smartsheet - Anyone Successful in Transitioning Policies and Procedures
I am attempting to transition our current Intranet over to Smartsheet and the biggest hurdle I currently have is around Policies and Procedures. We are a ISO certified company so document control is a important issue for us. Our current platform allows for linking within one procedure to possible several other procedures,…
-
How to copy a sheet without updating system generated columns Created By and Last Modified By?
I would like to back up a sheet that contains two system generated columns, Created By and Last Modified By, which currently are populated for all of the rows. When I tried saving the current sheet as a new sheet, all of my rows in the new sheet get messed up because many columns contain formulas that extract the data…
-
Formula to auto-transfer data into another sheet
The company I work for uses Smartsheets to build schedules. We have both weekly and daily schedules. However, I've noticed a lot of our time is spent daily going through and transferring information from the weekly to the daily grids. I didn't know if there was a way for me to auto-link certain grids to a grid on another…
-
I'm creating a form that will require hundreds of entries, how do I make this easy for the end user?
I'm recreating a form that was once a multi-tab excel spreadsheet. This link will be hosted on our webpage and will require users to list up to hundreds of names. What is the most efficient way for them to do this? Should I have them attach an Excel file to the form? I want to be able to upload the names to a potential…
-
Formula Assistance (COUNTM??)
Hello all, My team and I are hoping to build a formula to do the following: First, identify all items that belong to "Group A," then count how many items the rows that belong to group A have in "Color." So, for example, the answer for this would be 4 (because there are 4 items in the "Color" column that belong to Group A).…
-
workflow to be triggered when cell is changed to specific value
Hi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!