-
Is there a way to merge two Enterprise Account Users?
Currently there are two Enterprise Accounts created for some reason. So I am unable to add an Enterprise User from 'Enterprise Account A' through our User Management in 'Enterprise Account B'. As per instructions, if we delete these users from 'Enterprise Account A': 1. Will their Licensed User license be removed from…
-
Some Vlookups returning #NoMatch, others are fine
I have a training tracker with all the staff, their managers, locations and whether or not they have completed training. I have multiple vlookups in columns manager, location, role, status and classification. The vlookups are referencing an HR file that we have that has all the raw information. As you can see below, many…
-
auto completion date
Hello, fairly new to Smartsheet and I have a question. We have a sheet for PO requests and one of the columns is for "Status" , it has several options from a drop down menu. What I would like is for our "Completion Date" column to automatically show the date when a status is changed to "Complete". I don't care about any…
-
Interaction with Microsoft Sharepoint
Long story, short as I can make it. I started to create a list of links in Microsoft Sharepoint until I discovered that it seems to be woefully short with sorting, making child entries, etc. In Smartsheet, I am able to accomplish what I am trying to do with ease. Here's my question. Can Smartsheet and Sharepoint interact…
-
Alerts
Hi, I am new to Smartsheet - early indication is it is an excellent piece of software and will help me enormously. I just cant seem to find a way of alerting the assigned to person (of the following task) once the previous task has been marked as complete. I would have thought this was quite a common task but cannot see…
-
Importing rows from Google Forms
Hi, I'm setting up a form in Google Forms to collect data from users. The reason I am doing this using Google Forms instead of the native Smartsheet form solution is because I need to add logic in the form so that some fields become mandatory to be answered depending on a previous selection. Well, the issue I'm facing is…
-
Form Submission Automation
Faculty can submit a request for a course copy via a Smartsheet form I created. In the form, they are required to enter the name of their Program Director/Chair. If the name of the person requesting the course copy is different than the Program Director/Chair, I'd like to send an automatic request for approval from the…
-
Exporting options in Dynamic View
Currently, there isn't a way to export or print a dynamic view report. How do I create a report that provides my vendors with up to date status on all deliverables, allowing them to also be able to export the information onto an excel spreadsheet. My question is how can I design pull communication within a dynamic view…
-
Hi SS Community! Please help if you can...
Help, I'm trying to access an external smartsheet but am unable because I'm logged into Smartsheet with an email address that is different from the one the external ss owner sent to. After my account was originally set up, my IT group had to change my email address but it never got changed in my SS account. Any ideas? :)
-
Force Comment Entry
what code could I use, in a cell or range of cells, that would "force" a user to input a comment in a certain cell based on their selection in another cell? I have attached an example from my sheet - I would like, if a user chooses a "3" in column "sub rating", they are forced to enter a comment in the "comments" cell.…
