-
Best way to cross-reference multiple sheets for repeated values only?
Hello all! Looking for some advice here. I have multiple sheets that track guests invited to events (5 right now, but it will continue to grow). I want to create a something that references them and lists only people that have attended more than one event and which events they have attended. So for example, let's say on…
-
range checking & flags
Hi, I'm trying to leverage a formula to check if the employee ID is listed on another sheet. Sheet 1 (sanity check): This is where I want the formula to live. On sheet 1, if the employee ID on the row is not listed anywhere on Sheet 2's Employee ID column (range), then turn the flag on. If the employee ID on the row is…
-
Deeper AI Analytics
Can you make AI smart enough to compare multiple row attachments and create subtasks, summaries and/or compare and contrast information within said attachments? Similar to ClickUp Ai. Would like to be able to compare documents for similarities to uncover gaps for projects or create tasks based off of meeting transcripts…
-
Can a sheet-only Viewer see Workspace members or other collaborators on the same sheet?
Hi everyone, Quick question about sharing permissions in Smartsheet: If I share a specific sheet only (not the entire workspace) with someone as a Viewer, will they be able to: See the list of people who have access to the workspace itself? See the names of other people who are shared on that same sheet (the collaborators…
-
Pull data from a row
I'd like to pull data from a Smartsheet row, having designated specific columns, and put it into a document that can be printed.
-
Personal Account for Fun (And Practice)
I am always trying to advance my skills and so, being the unapologetic Smartsheet buff that I am, I now pay for my own personal Smartsheet account to play around and practice my skills on personal projects. In my heart I would like to someday live somewhere else and to help me determine where…. I built a Smartsheet. Using…
-
Copying column to another sheet
Hi, I have a sheet that includes a calculation to update the value in a specific column in real time. We'd like to track the values over time (monthly) and are looking to automate the process of copying the column and pasting it to another sheet, so we'd be able to create a line graph that shows changes over time. I am…
-
Managing @Mentions
I developed a comprehensive End-to-End Testing platform using Smartsheet. After my client completed their initial 4-week testing cycle, we held a feedback session. One key area they highlighted for improvement was managing the volume of @mentions using conversations they were receiving . They found it challenging to keep…
-
Uploading Attachments to Rows on Sheets
I am unable to upload files (PDF, docx, etc.) to rows. Is anyone else having the same issue?
-
Automation Help Please - Change Cell
Hello smartsheet community! I am basic familiarity with automations. I've created dozens, but they have all been fairly simple. Right now I am working on some automations for our project management templates, specifically our project plans to automatically when a task is delayed. I have created 3 separate automations…