Hi, I'll try to describe in detail what I want to do and would appreciate any help you can provide. I have a range of cells that show Red,Yellow or Green Balls and this is used to check the status of …
Hello all, I have been in the process to update email address for some of my contacts due to the change of domains. However in doing this I realized that all my sheets shared with those specific conta…
hi there, I am trying to count all dates that are on time comparing my due date column and delivery date column... tried countifs, but it wont let me compare the whole columns... please help. Thanks n…
Hi, I am relatively new to Smartsheet. I have built a portfolio of projects for our company. I want to identify what departments are involved in each of the projects in the portfolio. This is just a v…
Hello, Looking for a little quick assistance. Not sure why I can figure this out, but I guess I'm just not as intuitive with the SmartSheet logic. I have a metrics sheet that I am using to provide dat…
I am looking for an automatic way to generate reports that compare last month and current month. I have 6 account sheets that show totals by month and category. I would like to pull all 6 accounts int…
I create Reports frequently and am comfortable with the process. What I'm wondering is if there is an easy way to create a Report from within a Sheet that is based on that same Sheet? I guess I'm look…
I'm trying to take a spreadsheet and present it in a way that has one row for each category of item, and then multiple cells across that row to represent the emails sent in that category. This is a ca…
We're putting together a Proof of Concept for our project management team. We're "this close" to being able to replicate all the functionality they need. But, we're stumbling on one item. They would l…
