-
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
-
Lock a row (preventing editing) while row is open
Hi there, we have a scheduling Smartsheet that we're having some troubles with. Users are booking appointments in the below view, but since the row isn't locked out while this is happening, we're ending up with double-booking because two users overlap using the row. We have multiple people in the sheet, so if two people…
-
If column does not contain string return N/A
Hi, I've created a formula to return me the average "word" that appears when the Title column contains the string "1. Establish Baseline for Web Performance": =IF(AND(COUNTIFS(Rating:Rating, "Extreme-4", Status:Status, "Open", Title:Title, "1. Establish Baseline for Web Performance") >= COUNTIFS(Rating:Rating, "High-3",…
-
Formatting Charts
Hi all, I am trying to make a chart that references a report, and I have been successful in capturing the avg, and count values of groups I made inside the report. Where I am having trouble, is that I want to change the labels of the Legend. The legend pulls the name of the column it is referencing, however it is…