Best Of
Re: Assign a Program Code, without using Auto Number
In order to see what the program code is for a program, rather than leave it blank, my inclination would be to set-up a separate master data sheet that captures all unique programs, and assigns them a code with an auto-number. Then, the Program Code can pull in via a cell reference based on the value in the Program Name field (dropdown). Just a thought for consideration.
L J
Re: Index/Collect Two Separate Dates and Compare Them to Return Highest Date
It may not be the most elegant solution, but this will just compare the output of the two different formulas you posted and use the one with the latest date.
=IF(INDEX(COLLECT({Date_Engagement}, {Type1_Engagement}, 1, {ClientName_Engagement}, [ClientName]@row), 1) > INDEX(COLLECT({Date_Engagement}, {Type2_Engagement}, 1, {ClientName_Engagement}, [ClientName@row), 1),INDEX(COLLECT({Date_Engagement}, {Type1_Engagement}, 1, {ClientName_Engagement}, [ClientName]@row), 1), INDEX(COLLECT({Date_Engagement}, {Type2_Engagement}, 1, {ClientName_Engagement}, [ClientName@row), 1))
Carson Penticuff
Re: How to add varying months to varying dates?
I see what happened here:
the below should fix it
=DATE(YEAR([Date Contract Executed]@row) + ROUNDDOWN(([Months Until Expiration]@row + MONTH([Date Contract Executed]@row)) / 12.00001, 0), ROUNDUP(MOD([Months Until Expiration]@row + MONTH([Date Contract Executed]@row), 12.00001), 0), DAY([Date Contract Executed]@row))
Leibel S
Re: [GIVEAWAY CLOSED] [RECAP] Jumpstart 2025: Celebrating Community + BONUS chance to win swag!
Thanks everyone for entering this bonus giveaway opportunity! Congratulations to @markkrebs and @Will Duplex for being our winners and supporting the extra-ness of fireworks appearing after completing a task. 🤣🎇
Stay tuned for our official 10 Years of Community kickoff in February!
Alison C.
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