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 c…
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, …
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 ve…
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 …
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…
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 …
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 li…
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'…
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: Whe…
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 th…