Best Of
Re: Duplicating a Large Workspace
Alejandra,
Thank you. I have submitted a request. I also reached out to Support that same day, but I know that sometimes community members have come up with rather genius workarounds to things that "couldn't be done".
I was able to figure out a solution with the help of Support that, while not perfect, was able to get me what I needed.
Basically I created an empty folder within the original workspace. I moved the absolute bare minimum to this folder. I then saved that folder as new into the new workspace. I was able to then put the original workspace back in order.
The problem I was running into is that everything in the workspace is linked together in a very intricate build that I have been working on full time for over a year now. I needed those sheets to stay linked to each other, so I knew I needed to be able to save everything as new together at the same time.
Unfortunately you cannot select multiple items and save them. You can only select one item to save as new (even if that one item is a folder containing a bunch of items).
I was able to figure out the bare minimum of what I needed for my testing which fortunately was under the 100 item limit (barely).
Paul Newcome
Re: Welcome to the online Smartsheet Community!
Hi @Angie Hatfield,
Thanks for being a part of the Community since 2016, I just awarded you the badge. 😄
Rebeca S.
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