Best Of
Re: How can Smartsheet be utilized to create a searchable resource repository?
What i have done is link seperate Dashbards togeather like a web page. They can click on a title and go to another dashboard with different topics. Im sure there are other ways to do it but thats what i have done and because people are used to seeing this on the normal internet it dosent feel as clumsy as it really is.
You could use the links setup on the dashboard also.
Nathan Slatton
Re: Rich Text Widget Scroll Bar Change
Happy to clarify: in this specific scenario there was a misunderstanding with two of the support agents that received the initial tickets of the widget behaviour. Those tickets were still reported and tracked in the back-end, gathered for Engineering to double check / review when they had time.
This meant that the priority of that review increased with the combination of more tickets to Support and this specific Idea receiving additional votes (thank you to all who commented/voted!).
I double-checked with Support and can confirm that subsequent tickets were told that it was actively being investigated, not expected, so the response you see copy/pasted here does not represent the majority of Support responses.
Personally, I'm glad to see those agents direct members here because it helps to have public votes! We had more votes on this post than tickets raised, so seeing this response is incredibly helpful, for Support, Product, and Engineering. Product actively reviews this section of the forum and they respond to top-voted posts once a month. This means that as the votes increased, there would have been a response to confirm if it was expected or not down the line, even if the original support tickets were not reviewed.
You've all done the right thing! Opening tickets, commenting here, making sure your voice is heard.
Thank you,
Genevieve
Genevieve P.
Re: Automation to copy row at specific dates
If you can make a list of every date, you can use a formula to grab the correct date and put it into a column and leverage that in an automation. Granted, creating and maintaining the list is a manual process, but at least you only have one place you have to put each date one time. Then you would use
=MIN(COLLECT({Date Sheet Date Column}, {Date Sheet Date Column}, @cell >= TODAY()))
Then you would set up an automation to run daily with a condition of this helper column being equal to today.
Or is it different dates for different rows?
Paul Newcome
Re: Calculating the difference in years, months, and days between two date ranges
I wish Smartsheet had this functionality like Excel's DATEDIF function. I had to resort to creating formulas from scratch to replicate it. There are separate formulas to calculate the years, months-in-excess-of-years, and days-in-excess-of-months. Create 3 columns 'Years', 'Months', 'Days'. The following example uses today's date for calculation (7/30/2024). If you have static End Dates, create an End Date column and replace TODAY() with its reference cell.
Smartsheet Example
Excel Example using DATEDIF()
Years column formula:
=IF(DAY(TODAY()) < DAY([Start Date]@row), (IF(MONTH(TODAY()) <= MONTH([Start Date]@row), YEAR(TODAY()) - YEAR([Start Date]@row) - 1, YEAR(TODAY()) - YEAR([Start Date]@row))), (IF(MONTH(TODAY()) < MONTH([Start Date]@row), YEAR(TODAY()) - YEAR([Start Date]@row) - 1, YEAR(TODAY()) - YEAR([Start Date]@row))))
Months column formula:
=IF(DAY(TODAY()) < DAY([Start Date]@row), (IF(MONTH(TODAY()) <= MONTH([Start Date]@row), MONTH(TODAY()) - MONTH([Start Date]@row) + 11, MONTH(TODAY()) - MONTH([Start Date]@row) - 1)), (IF(MONTH(TODAY()) < MONTH([Start Date]@row), MONTH(TODAY()) - MONTH([Start Date]@row) + 12, MONTH(TODAY()) - MONTH([Start Date]@row))))
Days column formula:
=IF(DAY(TODAY()) >= DAY([Start Date]@row), DAY(TODAY()) - DAY([Start Date]@row), IF(OR(MONTH(TODAY()) = 1, MONTH(TODAY()) = 2, MONTH(TODAY()) = 4, MONTH(TODAY()) = 6, MONTH(TODAY()) = 8, MONTH(TODAY()) = 9, MONTH(TODAY()) = 11), 31 - DAY([Start Date]@row) + DAY(TODAY()), IF(OR(MONTH(TODAY()) = 5, MONTH(TODAY()) = 7, MONTH(TODAY()) = 10, MONTH(TODAY()) = 12), 30 - DAY([Start Date]@row) + DAY(TODAY()), IF(AND(MONTH(TODAY()) = 3, MOD(YEAR(TODAY()), 4) = 0), 29 - DAY([Start Date]@row) + DAY(TODAY()), IF(AND(MONTH(TODAY()) = 3, MOD(YEAR(TODAY()), 4) <> 0), 28 - DAY([Start Date]@row) + DAY(TODAY()), "ERROR.")))))
Years, Months, Days Concat formula:
=Years@row + " Year" + IF(Years@row = 1, ", ", "s, ") + Months@row + " Month" + IF(Months@row = 1, ", ", "s, ") + Days@row + " Day" + IF(Days@row = 1, "", "s")
I believe this will do what you are looking for and also accounts for leap years. I tested a wide range of dates, so this should work exactly as Excel's DATEDIF().
smdinhphan
Re: Sort Card View to have High Priority on the top
hi @Isaac A. ,
thank you for your answer and link. I will vote it up.
kowal
Re: Combine (Concatenate) Text or Values from Two or More Cells into Dropdown List Column
You would use this as your delimiter:
CHAR(10)
Paul Newcome
Re: Smartsheet & Outlook Invites for meetings
Hi @mhint2005 - we got your enquiries and responded to both, if you're not seeing our replies, please reach out directly to me on lindsay@infospark.com.au
Cheers,
Lindsay
Re: Smartsheet Profile
Hi @Sherry Fox
Thanks for the suggestion! This is the first time a secondary email has been suggested for Community specifically, and it has not yet been explored as a possibility. If you have a secondary email on your Smartsheet account (such as your personal one), then you can make this your Primary email and use it to sign in to the same Community profile that way. Here's the article on Primary and Secondary emails in Smartsheet.
Please feel free to post this as an Idea the Community Ideas topic so other members can vote on it and provide their feedback as well!
Cheers,
Genevieve
Genevieve P.
May Question of the Month - Join the conversation and receive a badge
Hey Community!
Last month we asked about your desk treasures, and it was a joy to read all the stories behind them. There was a bit of everything — a 3D printed dragon, your kid’s sweet notes, more than a few coffee mugs, and fun coworker gifts (like this wooden frog)! I loved seeing you connect while sharing how much meaning these little objects can hold.
Now, let’s switch it up again. Here’s a fun new chance to earn a badge and get to know your peers along the way.
How would you describe your job to a five year old?
I’m really looking forward to seeing what you come up with! Let's see how you break down your job for the little ones.
Share those kid-friendly explanations in the comments below. ⬇️
About Question of the Month:
We kick off each month with a new question. These monthly ice breakers are just one way to help you get to know your Smartsheet peers and rack up some badges and points in the process.
Everyone who participates by answering the question prior to the end of the month will automatically receive a unique participant badge once the question closes at the end of the month.
In addition to the participant badge, the top three answers based on Community member votes will receive the Top Answer badge. To vote on an answer click on the upvote icon associated with an answer in the comments below. Multiple votes allowed and encouraged!
Rebeca S.
Re: Auto-Populate Data from Master Sheet Based on Textbook Selection (No Automation)
Thank you! I used INDEX MATCH, and it worked perfectly. Appreciate the help.
SNH