-
Syncing cells across sheets.
I have a process where I have multiple users entering data into their own individual sheets. I want copy from those multiple sheets into a single master sheet. I also want to update the master sheet cells any time a cell is updated from the individual sheets. I have been able to get this working, but the linking process is…
-
Populating Entire Columns Referencing Another Sheet
Hi all! Over the last week or so I have been trying to build a report that shows average tasks completed over a given 12 week period. So far I have been successful in creating the formulas for these, which have been working on dummy data. Now I would like to process live data from another sheet. Well ideally I would…
-
Lookup Columns Between Sheets
Good day all I'm a newbie on the community. I'm trying to deal with a scenario which I thought was very common and assumed Smartsheet would have an easy way to deal with. The scenario is: we have a very simple sheet for managing customers. This sheet includes a customerID, business name, primary contact person, postal…
-
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.…
