Best Of

Re: May Question of the Month - Join the conversation and receive a badge

Imagine you have a big box of toys, and you want to make sure everyone gets the toy they like the most. As a Business Analyst, my job is kind of like that! I help people figure out what they need and how to make things work better. I look at all the toys (or information) and decide the best way to share them so everyone is happy and things run smoothly. 😊

Ray Lindstrom

5 ·

Re: Bottom Scroll Bar disappears when a notification appears

This has been annoying me for a while. I haven't even noticed when it exactly happens, I thought is was random. But I found that minimizing/shrinking the browser and then restoring back to normal size, brings the scrolling bar back.

Thiara Perez

1 ·

Re: How do I get a formula to understand that 10 is 10 and not 1? It is not factoring in the zero.

Hi @Amber Bailey UNM ,

Wondering if removing the "" around 10 would make it recognize it's a number?

If it is pulling from a date column, perhaps using if(LEFT(Month@row, 2), 10, "") would get you the correct item?

hollyconradsmith

1 ·

Re: May Question of the Month - Join the conversation and receive a badge

I'm a strategic data analyst!

Meaning I use what I can measure and observe (data) to form good ideas and opinions (analyst) about how to make the best plans for my business (strategic).

I'm like my team's gardener! I look at how well the garden is doing to see how we can grow more plants each season. If a certain type of plant is doing really good, I know that we should plant more. If a plant isn't doing well, I try to see if there are small changes we can make to help it grow better next time, like giving it more sun or watering it more often.

By looking at how happy the garden's plants are, measuring how big they grow, and paying attention to things that hurt the plants, such as cold weather or pests, I help my team's garden grow and become more amazing each and every year.

Almonto1

3 ·

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

1 ·

Re: Rich Text Widget Scroll Bar Change

Hi @Kyle Chipman

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.

1 ·

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

1 ·

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().