-
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?
-
How identify where actual lag time is different from standard lag time?
Need a way to identify tasks on my workplan where the actual lag time is different from the standard lag time. My workplan includes: 1. Predecessor column (includes predecessor with +/- lag) 2. A separate text column "Standard Lag Time " Whenever the lag time needs to be changed the predecessor column is updated. The…
-
Sheet Summary COUNTIF
I'm having problems using the COUNTIF function in the new-ish sheet summary. Everytime I sort rows it changes the range. For example, in a summary text field I have =COUNTIF([Column A]1:[Column A]79, =0) After sorting by a column it becomes =COUNTIF([Column A]29:[Column A]43, =0). Or something similar. The sheet summary is…