-
Help with a weekly updated formula
Hello! I'm still a beginner smartsheets user, and while I am decent with excel the live updates is still very new. I'm trying to create a formula that will pull information on a weekly basis, M-F, that updated for each week and didn't pull from the previous week at all. For example in this screenshot, I would like a…
-
Report Creation tool within a sheet
One of my most frequent uses of Smartsheet is as an editorial calendar for a weekly newsletter. I create a new sheet for every month of the year. Exiting a sheet and creating a report is not too much of a hassle but, it would be nice if I could click a button within a sheet that automatically opens a new page that is a…
-
COUNTIFS formula error
I am trying to calculate training sessions based on 2 columns : status column and year column. I've done this numerous times before however for some reason no matter what status filter I choose the outcome is 0 when there are definitely values for 2024 completed training sessions. This is the formula I am using =…
-
FORM Links - same link moved to different sheet
It would be a great idea for tracking and traceability purposes in sheets, to have the kind of on and off button that allows the same form link to be associated with different sheets. Meaning that lets say i want to start a new sheet each year, but i want to keep the form link to be the same. This can be overpassed by the…
-
How to copy the latest comment in a row to a cell?
Hi all, I'm building a new sheet where we want to use the comments function, but I'd like to have a "read only" of the latest comment left by a user and with the time a date in a cell. This would help summarize the latest detail on a report or a first look at the sheet, and then if they want to check the history they can…
-
How to auto populate approval from one sheet to another?
Sheet 1 has the column of Name (Text) Email (Contact List) Request (Text) Approver (Text) Approval (Yes/No - Dropdown) Sheet 2 has the columns Approver Name (Text) Approve? (Yes/No - Dropdown) Once the form for sheet 1 is submitted I have it automated that it'll trigger an email to the 'Approver' contact list to open up…
-
Milestone Trend Analysis (MTA) Chart creation on dashboard
Hello, I'm adapt/add a Milestone Trend Analysis (MTA Chart) on Smartsheet. Is there a way to reflect his on a dashboard. Here is a copy of what I would like reflected on our dashboards. Not my data but I saw this for usage with MSProject. I'm looking to have sheets with data and project/display this data on the dashboard…
-
Form Entry Metrics by Category
I'm creating a metrics sheet that will have data input by external parties via a form. I'm trying to think of a simpler/more user friendly way to display categories on the sheet and form. There are many category options and I need the # of occurrences entered for each category to tabulate monthly metrics. Most of these…
-
Best Practice: Intake Sheet & Secondary Sheet when 2-way sync is needed
We're working on a solution for a department that is similar to Uber without the bells and whistles. A call comes in when there's bad weather, a city employee "aka Dispatcher" looks to see who is available in our list of drivers and assigns them to pick the employee up. I think my question is pretty simple? I'm having…
-
Feature request: Hashtags to create automatic reports
Hello! So, the story is: Our team is using a Smartsheet workspace to coordinate the production and deployment of assets of an entire Content and Marketing department. We have created sheets for each type of process/asset (Social Media, Video, Print, Web, Email Marketing, etc), automated formatting in all sheets according…