Best Of
Re: Easily identify all Reports impacted by a column change or removal
Yes!!! I need to do this today! =-)
Pauline J
Re: Contact List Functionality in Forms
Boosting this - my use case is that I have a form that needs to be filled out quickly and accurately, and it will be filled out by the same user every time but each entry on the sheet will likely have a different email address in the "email address" column. I'd like to have the "email address" section autofill based on the first few letters typed. I can do this manually by selecting individual contacts within the column settings, but for 150+ email addresses needed. Please update contacts list functionality!
mchapman
Re: How can I see a list of all dashboards that I have access to?
Hi @Angie Hatfield,
Not without being an admin and using Admin Center to view the resources a user has access to.
As a user, you have to navigate to and/or search for them manually.
It would make for a good Product Idea submission (if you don't first find one already entered that you can upvote).
BRgds,
-Ray
Ray Lindstrom
Re: Welcome to the online Smartsheet Community!
Thanks @Rebeca S. , have a good day & weekend!
Angie Hatfield
Re: Count Values of X if Y is not the same for the other Xs
The helper column counts the number of times the advisor appears with 1 in the Meeting Number column. If a given advisor is listed with four different clients, the helper column will show 4 on each of those rows. I did miss the "2024" condition in my previous post, so here are the formulas revised to include the year.
Helper column formula for source sheet:
=COUNTIFS(Advisor:Advisor, Advisor@row, [Submission Year]:[Submission Year], @cell = 2024, [Meeting Number]:[Meeting Number], @cell = 1)
Formula for 2-4
=COUNT(DISTINCT(COLLECT({Advisor Namex}, {Submission Yearx}, @cell = 2024, {Meeting 1 Helper}, @cell >= 2, {Meeting 1 Helper}, @cell >= 4)))
Formula for > 4
=COUNT(DISTINCT(COLLECT({Advisor Namex}, {Submission Yearx}, @cell = 2024, {Meeting 1 Helper}, @cell > 4)))
Carson Penticuff
Re: Automation Workflow Q: Daily Email w/ Multiple Criteria
Hi again @Sam_Harwart -
Just wanted to confirm that I ran a test overnight using your suggested solution and it did work - so thank you! My only outstanding question/concern is #2 from my response above:
2) For the Notify column in the Main sheet, can the formula be modified to check both the Staff Lead column and the Additional Staff column? Using myself as an example, there are known scenarios where within a single day I could be the Lead for several on-site activities, playing a support role for another activity, and we would also have an activity assigned to the Full Staff. In this scenario, each of those activities should be included in my email notification. I tried appending it myself, but got an "Incorrect Argument Set" error
I'll do some digging around to try to figure out how to fix that formula to also include the "Additional Staff" column, but if you have any tips, I would appreciate them.
Thanks again!
Frannie
FGarvey
Re: January Question of the Month - Join the conversation and receive a badge
I've been a Community member since April 2016!
On my bucket list is to move somewhere I know nothing about and no one at all! I want to travel to places that no one goes to. I want adventures and fun!
Now I look back a hundred years ago when I first left school, I wish I had become a nomad and traveled aimlessly for a few years instead of jumping right into work.
Money isn't everything!
Angie Hatfield
Re: Invoiced, yet license not applied - now down to free licenses, support non responsive
Thanks, was indeed EU but also another issue that support reached out after this and resolved it.
slewis1972
Re: How can I pull through the latest entry in a sheet to my dashboard?
Instead of pointing your metric widget to a cell within your grid, I would use a Sheet Summary field to capture the Health and Update from the latest entry in the grid and point your dashboard metric widget to the Sheet Summary field instead. That way no matter how many rows are added, your dashboard will always display the info from the most recent row added. Consider using a Created Date auto column on your grid (you can hide it) for the Sheet Summary field to examine to determine the most recent entry. That way in case rows get reorganized, you'll still always be capturing the data from the latest entry.
BRgds,
-Ray
Ray Lindstrom
Re: Help with SUMIFS
I modified the demo sheets to fit your setup.
a separate worksheet, Assigned To, Numerical Size 1 and Date Task 1 Completeare collected
I added helper columns like Week Start (Mondays) to help input the data.
SUMIFS Sheet
The SUMIFS formula is as follows;
=IFERROR(SUMIFS({Employee Data : Numerical Size 1}, {Employee Data : Date Task 1 Complete}, WEEKNUMBER(@cell) = WEEKNUMBER([Week Start (Monday)]@row), {Employee Data : Assigned To}, [Assigned To]@row), "")
The IFERROR is for the top row where we do not have any data for dates and Assigned to.
The SUMIFS function sums the {Numerical Size 1}-range of the first sheet whose {Date Task 1 Complete}-range's week number is the same as this sheet's [Week Start (Monday)]'s week number and {Assigned to}-range is the same as the current row's.
"Smartsheet calculates week numbers based on Mondays," so this formula suits your needs.
Please note it is not recommended to try to get the Date Task 1 Completes as dates because there can be more than one date that meets the SUMIFS criteria. (You may be able to use the JOIN function as used in the first sheet's helper columns.)
