Smartsheet Basics
Archives for November 2019
Discussion List
- Sometimes more than 1 course is taught at the same location. I am being asked to count the number of courses taught, quarterly. On rare occasions, a course is not taught and OTHER is entered in that c…
- = IF[Instructor 1 Last Name]@row = "" - AND [Instructor Status]@row = "U.S. Instructor" - I need it to count as 1. Otherwise, 0. What I've written above is what I want to do. Below is the formula, whi…
- What am I doing wrong? I am linking cells from one sheet to another. When I do so I select two cells and then link them to two cells in another sheet. However, only the first cell has a link not the a…
- Can anyone explain how to connect Smartsheet reports to MS Power Query? I have tried creating API Tokens to connect some of my reporting, but I’ve been unsuccessful. I can “halfway” Access the Smartsh…
- Hello, Please can anyone help me with a CMMS template to adapt and use? Thanks
- Trying to create a data page based off another sheet to create counts of tickets (sync wit JIRA) that were closed withing a month. I have a column in the main sheet for "story", one for status "done" …
- I have a sheet which requires updates and approvals by multiple individuals. I want to create an Automated Workflow that assigns approval by row, whenever there is any change to that row. All rows, ob…
- Have other admin experienced issues when setting up SAML using ADFS 5? The metadata that we receive from Smartsheet produces an error, which we can move forward with to create a relay. However, the en…
- I created a basic project sheet and have been filling in tasks for two main deliverables (both shown as parent rows). Under those two parent rows are several child rows. However, the % Complete column…
- Hi there, i'm trying to figure this out: I have sheet #1 with an email address field. When that field is updated, Smartsheet automatically updates sheet #2 email address field with the email entered i…
Trending in Smartsheet Basics
- Hi Smartsheet superusers! Ok, so I used Smartsheet with a previous employer for a few years and it's been about two years since I was really working in the system. My potential new employer uses it an…
- I have data on a "copy of construction checklist" that has been shared to me. I am an admin to the shared copy of construction checklist. If the owner of the sheet, cycles data off the sheet due to co…
