-
Compile a list of unique values
I've been playing around with this all day. I'm trying to figure a way to compile a list all the unique values in a given column (in this case, business entities/customers). I'm matching that against an "Inactive" checkbox and trying to end with a list of all customers with currently active projects. Ideally in a report so…
-
COUNTIFs across multiple columns from another sheet
Hi all, I'm currently struggling to execute a formula to count the number of times a contact appears across multiple columns from a sheet I'm referencing. I know I can just add two COUNTIFs statements for each column but this doesn't solve my problem of only wanting a contact to be contacted once for each row (eg if the…
-
Weekday Function that displays last 7 days
Hello, I currently have a date column with =Today() that tracks the current last 7 days plus the current day, this is paired to data that occurred on the corresponding day in order to display metrics on a dashboard. As you can see there are zeros on the 25th and 26th as it was a weekend. I am trying to utilize the =Weekday…
-
How do I set up my sheet to reflect changes made in another sheet?
Hello! I am new to Smartsheet and trying to figure out how (and if it's possible) to set up a workflow or formula to reflect changes made in another sheet. Currently, I have one sheet set up that's linked to an intake form. I am using this sheet as a "master sheet" to track all submissions. Additionally, within this master…
-
PMO Template - Issues with Project Intake Form --> Project Intake Sheet
Hello All! I wanted to see if someone could assist me with fixing a bug I created. I was using the Project Management Office (PMO) template set and the 'Project Intake Form' and 'Project Intake Sheet' - the connectivity between the two (aka when I use and fill in the form, press submit, it would generate a new Project ID…
-
Emoji Icon Viewable When Printing to PDF
Using emojis is a game changer for tracking data and keeping data clutter to a minimum. However, in some cases, we still need to keep physical copies regularly for the sake of archives. The Issue: When printing the sheet to pdf, the emojis used do not appear. I've created a sample that does not use any confidential or…
-
Emoji Showing on Grid - Not Showing in Print to PDF
Using emojis is a game changer for tracking data and keeping visual clutter to a minimum. However, we still need to keep physical copies regularly for the sake of archives. The Issue: When printing the sheet to pdf, the emojis used do not appear. I've created a sample that does not use any confidential or non-secure data.…
-
Creating a dashboard from a sheet with multiple data types
Hey all, attached is a screenshot of a sheet I am trying to create a dashboard with. The issue I am having is creating a chart/view to show completion of a year review meeting by student. The 'Complete?' check box is what we are using to mark completion of the meeting. When I try and make a dashboard from this sheet and…
-
How to create a source sheet that automatically updates other sheets if data is removed?
Our organization has roughly 150 program participants and we have a number of different sheets that have each participant listed as a row with various data in columns. I am curious if anyone has experience with creating a source sheet of contacts so that if I add/remove a participant from the source sheet, they get added…
-
How to append sheets/consolidate multiple sheets in one sheet
Hi All, here are two different sheets populated from two different forms which are site specific The forms have information for people to read which are site specific hence why two forms Is there a way to append these two sheets into one like you can do on power bi using the append query function? please can you advise