-
How to pass Row Number to MATCH function?
Hello all! I am trying to work with the MATCH and VLOOKUP functions, to create alerts to let people know it's time to begin their assigned work. For example, if Task 2 is a predecessor of Task 3 (that is, if [Predecessors]3 = 2), I want to do a MATCH and VLOOKUP on Row 2 that shows [Assigned To]3. That way, when [Status]2…
-
Shared User Removed... By Terminated Employee??
This morning I received a note that a shared user was removed by that same shared user. Clayton Harris was terminated a few weeks ago, but it says he removed himself from this specific sheet. Very alarming! His SSO account was deactivated. It looks like he still had access! In the Activity Log, you can see our head of…
-
Card view filter Current User
Hi, I have a form to submit new request items. I've added a "Created By" system column to cupture the user submitting the request. After a user submits a request, this column contains the user email address. I've published a "Read Only-Full" Card view for the users where they can see all the submitted items. I also added a…
-
Querying a column from another spreadsheet
I have two tasks sheets. I use one to monitor "projects". I use another to monitor "tasks". I would like to add a column called "Associated Project" to the tasks sheet. I know I can go in individually to each cell and have it link to a cell in the projects sheet. I also know I can set up a dropdown list with a projects.…
-
Send a notification to an email address submitted in form.
Hello, I am currently using SmartSheets for our staffing agencies to submit potential candidates to open requisitions. On our side of smartsheet, we have a drop down with the "status" of the candidate (Pending, submitted to hiring manager, rejected, hired, etc) that helps us process submissions. When an agency submits a…
-
DASHBOARD & MONTHLY REPORTING
Hi. I have a Dashboard that reports my team's activity/request. However, it reports everything from the initial entry to date. How can I only display activity from the current month (automatically)?
-
Web forms, is it better to add at top or bottom
I have been using web forms to populate existing sheets with new data. But I have a question as to whether it is better to have new data at the top of the sheet or the bottom? 1. I see that updates are referenced by row number, so if I have data come in and an update request is sent out. And then new data is added at the…
-
Best way to append text in a cell?
Hello, We have a project tracking sheet into which people will be adding status updates to a particular cell. Is there a way to easily append the text to the previous text so we can retain history? People can use "Alt-Enter" to create a new line but then cells get very large. Is comments the best way to do this? People…
-
sync rows between sheets
We have one large master action list for all clients. I'd like to be able to automatically pull data from that list so we can see at a glance what needs to be done for a specific client and save that on a tab in teams.Ideally I'd like the two to sync so changes made in either are replicated. I don't think cell linking…
-
Filter by color
Is it possible to filter a column by color? We use visual management extensively for some of our larger enterprise projects and filtering by color is helpful. I didn't see a way, not sure if there was a "trick".