-
Setting Up Automated Transfers between Sheets
Hi all, I'm trying to sort out if it's possible to have information automatically transferred from one sheet to another. Essentially, I'm hoping to create an automated archive that absorbs all information in our primary sheet once an item has been fully addressed. I haven't come across anything in the training videos that…
-
Countif lookup by email/contact
Hello - I have a sheet ("Sheet 1") where users enter various entries/plans, etc. via a form and to associate it with themselves, I have them use their email address which logs into a contact column. In another sheet ("Sheet 2")- I have a list of everyone who is expected to put in information. I have a contact column with…
-
Teams Integration
Hi All, I have been tasked by my manager to incorporate SmartSheet into Teams. We have completed the integration and I can now see the shared sheets in Teams without issue. We would like to go a step further and be able to receive notifications in Teams when certain fields are completed on the Sheet. Is this possible?…
-
Smartsheet down in certain area's ?
Dears, Writing on the community as I am not getting any feedback on the support tickets. Our Malaysian department (both our co-workers + local customer) is logging in but not able to work as the sheets are not loading - see screenshot. Systems have been rebooted / logged out and in again and local IT checked - our end is…
-
INDEX/MATCH Formula
Hello! I'm creating a document where I would like to index a column of dates, and return a specific date from that list. I need one of two things to occur: 1) If a date occurs in the upcoming week, I would like to return the latest date of the week 2) If no date occurs in the upcoming week, I would like to return the…
-
Idea on connecting two Smartsheets?
I have two sheet that i want to reference and update each other. They both follow similar formatting, with one being more of a log/reference for the other. I would like one list to dynamically update the other. How would i do this? Items list - I have a items list that will show an overview of purchase orders to be done…
-
Auto-Number creating duplicates!
I am using an Auto-Number column in my sheet to generate a new Request ID with every entry. I noticed this morning that there are duplicates of the same Request ID in the sheet. This is a concern because the RQID needs to be unique for each record. There are two ways a record is created with the sheet. One is if a user…
-
Can you sort rows or filter in the iOS app?
I am trying to sort a list from ascending to descending in the iOS app. Or filter out values less than a certain number. Seems like this would be very standard functionality for a spreadsheet. Am I missing something? Any help would be greatly appreciated.
-
How do I delete a Dynamic View that no longer works
Getting the message: "This view is currently broken. Please contact the view owner." Unfortunately, the owner of the sheet no longer works here. I need to clean up the dynamic views as they are causing confusion. I am an administrator for the company account.
-
maintenance sheet work machines
Hello, Does anyone know how to make these cards (type card attached screenshot), connected with SmartSheet that can be connected to another management control worksheet?