-
REMOVE IF SLOT IS TAKE
Hello! Can we remove a time slot in the drop down on a specific date if it is taken. Below is an example. For example if someone Booked - Dec. 31, 2023 - 9:00AM - 9:20AM, can we automatically remove that from the drop down list since someone booked it? What are the ways?
-
How To create a revenue summary formula
How can I create a formula where by I have rows containing different projects, their value and the dates they will start and end and create a summary to show in what months will generate what value (assuming the value is divided equally over however many months the project spans) i.e. Row 1 is Project X with a value of…
-
link between sheets
Hi! I'm working with two different sheets. The first one has all marketing activities (webinars, events, trade show, etc). The second one has all the marketing assets created (Ebook, social media cards, etc). I would like to link which assets can be used for which marketing activities. A marketing activity can use more…
-
What is the simplest way to have data from a form be pulled monthly into reports/dashboard
I have created a smartsheet form to log information on service intakes. I have then created sheet summaries and reports with a bunch of information (age, demographic, reason for call, type of service requested etc.). From this I created a dashboard showing key metrics and graphs of my data. My challenge is now I would like…
-
How do I use the attachment column in a Sheet Summary Formula?
I want to write a sheet summary formula that counts how many rows where the MoSCow column contains M, have attachments. The syntax I am using is COUNTIFS( range1, criterion1, [ range2,criterion2]). I have used this formula many times Getting the column criteria (range 1, criterion 1)specified is straight forward. But I…
-
Formula for "Days since" event
Hi There, I'm looking for some help with a formula for a sheet summary field. I'd like the field to display the number of days since "today" that a checkbox was checked, based off the date entered in that checkbox's row. Example based off screenshot: "Today" is 12/4/2023. If the checkbox for Row 66 is checked the "Days…
-
Report Grouping Issue
I have report that summarized about 38 sheets using sheet summary fields. For some reasons, one of the fields isn't coming through so the report is not grouping properly. It's only happening for a few sheets but it's the third time it's happened this week. To fix it I have to go in to each sheet summary, take a letter off,…
-
Converting Sheet Summary Metrics to be used on Dashboard
Hola! What's the best way to convert sheet summary metrics into data that can be visualized on a dashboard? Muchas gracias in advance.
-
Viewing team capacity over time
I am trying to see my team's capacity over multiple projects for each week to see who will have capacity to take on new projects. In the past I've done it by hand to look like this and I know in my mind the demands of each phase for a given project. This is quickly becoming unsustainable as we grow. I have a task list for…
-
Update sheet summary field via a report
I am using row reports and sheet summary reports. When I create a row report , I can edit fields in the report and it updates back into the plan /sheet itself. This makes it easy for me to meet with a team member and review only their tasks across my plans and update % complete etc. Similarly, I'd like to be able to pull…
