Best Of
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!
Re: Can Entries be Added in to the Calendar App from the Calendar itself? see screenshots
This looks strange, can you try another browser and also check once from the below help document you hvae followed all the steps correctly.
Calendar App | Smartsheet Learning Center
Warm Regards
Re: Smartsheet Comments tags person in Slack
Hi @Humashankar - I can add them as a contact in Smartsheet but when I make a comment, it will not allow me to @mention them. I just found out that this cannot be done.
There currently isn't a way to have the Smartsheet notification sent to Slack automatically @mention a specific person within the information sent. You will want to start a thread in Slack under the specific form response and @mention the user manually in a comment.
Re: In access request alerts please include a second button to share the workspace
YESSS! I had to remove all the admins from my workspaces with this change that made it easier for sysadmins but hosed solution engineers. 🤬🤦♀️