Best Of
Report as a web content widget?
I'm looking to make a report available as a web content widget. However, the only option when publishing the report is "Read Only". I need this report to be interactive right on the dashboard. Is there any other way to accomplish this? A report widget does not allow me to edit the report content on the dashboard.
Re: Countifs formula to count tasks in a range last 7 days to future 7 days
@SS_user10294507 I see 2 errors with your formula, there a parenthesis right after in progress which shouldn't be there but at the end .... (+7) ). if that doesn't fix it then I suggest something like this: =COUNTIFS(Owner:Owner, "Joe", Status:Status, "In Progress", Due:Due, AND(@cell >= TODAY(-7), @cell <= TODAY(+7)))
Re: Countifs formula to count tasks in a range last 7 days to future 7 days
Hello @SS_user10294507
If this was a copy/paste of the function. Then there's no close ")" to your COUNTIFS function.
Re: CountIfs Function to Determine if Completed on Time
HI @AshleyDeichmueller , I feel your pain! I am not aware of a way to compare two values from the same row of a different sheet in a formula like you are attempting to do that also involves counting or summing multiple results. If the Due Date were the same for all of the projects, then you could do it, but I bet that's not the case.
I also appreciate limiting columns to avoid going over SS limits. Keep in mind that you can have up to 400 columns and 500,000 cells in a sheet, so there is a lot of room, even for a relatively large inventory with 1000s of rows. If you are looking at 10s of 1000s of rows, you can consider archiving old data into a second sheet. You can always bring the "active" and "archived" data into the same report if needed. If you are truly coming close to the limits, you are also probably experiencing slow processing times when you open, save or add rows to the sheet. Automations can sometimes take a long time to fire, etc. Archiving can help with that too... and you can create automations that will automatically archive rows as needed.
I realize this isn't exactly what you are looking for, but perhaps it will spark some additional solutions. Adding an On Time column really shouldn't throw the whole design into a tailspin. BTW.. another idea: if you already have a project "status" column (especially if it is calculated with an IF() statement), you could add a new value that represents when a project is completed late. Then you could use that value in your COUNTIFS()
I hope this helps. Be well.
Re: Automation Email Alert Issue - Grouping Notifications with Unique Subjects
Hey @admin_smartsheet_lpc, regarding your drawback...
"One drawback is if I need to update the custom message, now I have to do it 10 times. 😕"
...I typically create a calculated column for my custom message (which can be different per row) and just put a reference to that column in the workflow message field. Then, if you need to update your message, you can just change the column formula and leave the workflow alone. I usually create separate columns for Subject, Body, and sometimes Recipient. 😉
Re: [GIVEAWAY] Win 1 seat to a Multi-Day Smartsheet University course
Hi! My name is Nancy Benter, pronouns are she/her, and I'm a Strategy Leader at Starbucks. One of my most memorable training experiences was with Right To Be, an organization focused on global, people-powered movement to end harassment. To further invest in my leadership, I participated in their Bystander Intervention training. What stood out to me was every 2-4 minutes, there was a live knowledge check to assess your understanding of the bystander scenarios. The facilitator also did an incredible job with storytelling and sharing examples from her lived experience. At the very end of the training, we were left with actionable recommendations in a digestible activity guide so we could carry forward our learnings.
Re: Display Pie Chart in a Dashboard
Hello @1996mustang
This is typically a problem when you have more information on a sheet than just numeric values, and text to describe those values. If you create a report from that sheet with the first column as the information label, and the second column as your numeric count, you should be able to create a pie chart from the report.
Hope this helps! Thanks
Re: Changes to asset Admin permissions and new Plan Asset Admin role, now generally available!
Adding insult to injury, not only is there no method to determine who has this new role, the user list does not even count the Plan Asset Admin role as a role:
I had 7 roles prior to adding PAA and have 7 after adding that role.
@QuanT Do we really need to request an enhancement for something that should have been done before this change was rolled out?
Re: Is there a way to get two return values in an IF function?
Hi @GTR
Try this:
Replace "[Personal Email Address]@row +"; " + [Professional email address]@row" with:
IF(ISBLANK([Personal Email Address]@row), [Professional Email Address]@row, [Personal Email Address]@row +"; " + [Professional email address]@row)
Re: How to count the number of photo shoots, not completed, by brand? COMPLEX???
Hi @Shawn_K2 , Have you attempted to create a report and specifying the filters that you listed? If not I would try that route first to see if that meets your need.
Within reports, I would recommend looking into Filters, Grouping, and Summarize. These are all features that you can find solid help for within the community.
If you make a little progress, but need some additional help, share a little more about what you've tried. I'm happy to help, but it's hard to describe without knowing what you've been trying.
I hope this is gets you going in the right direction. Be well!