Best Of

Re: Add Months to Date formula?

Slight edit added...

Dealing with months is somewhat tricky.

"How" do you want to add the months? Here are a few examples of ways to deal with months:

With a start date of 01/31/2024 and adding one month... simply incrementing the month will give you 02/31/2024, which is obviously not possible.

The average month length is 30.4375 days (factoring in leap years as well). This can be rounded down to 30 days. A start date of 01/31/2024 and adding 40 months (40 x 30 = 1200) will return 04/15/2027 as a result. Mathematically this makes sense, logically you would expect the result to land in May. I believe Smartsheet essentially does this in the background so it is the easiest to implement.

Going back to our first example (Starting on 01/31/2024 and adding one month), we could approach this a couple of different ways. We can say that any result that lands on an "impossible" day just gets "pulled back" to the last valid day of the month. So 01/31/2024 + 1 month would return 02/29/2024 (leap year).

The other option is to have it roll over to the first day of the following month. 01/31/2024 + 1 month = 03/01/2024.

How you would prefer to handle the result will dictate how to approach this.

Carson Penticuff

2 ·

Re: Can automation create a new sheet from a template?

Hi @Nancy Williams

You can automate the initiation from the Approval column, however optional items will be skipped and it will only include required items.

Cheers,

Genevieve

Genevieve P.

1 ·

Re: Column Dividers in a Sheet

Hi @Kendra P,

I use the same thing; formatted columns as dividers. One thing is you have to use a different name for each one.

Sometimes I use a period for my first, and 2 periods for my second.

Sometimes I name the column separators which helps when scrolling through many columns. It's like column group headers, but as columns instead of headers.

I don't believe there's any other option to separate out sections of columns (like in Excel).

Would make for a good Product Idea to submit though!

BRgds,

-Ray

Ray Lindstrom

1 ·

Re: NEW! Dashboard Builder Enhancements

All great stuff. Now if we could just get something into the mix regarding automation to send out a published dashboard via email on a scheduled cadence, we’d be in really great shape.

Steve Robinette

1 ·

Re: NEW! Dashboard Builder Enhancements

Id really like to see the ability to have filters. currently dashboards with multiple facility builds is not UX friendly or build friendly.

Willlybolt

1 ·

Re: Looking to count how many 'scheduled' statuses we have in 2023 by month.

You should have a {Cross Sheet Reference} for that last range.

Also looks like you may have an issue with your quotes. See how some are straight up and down ("NSP") and others are slanted (“Scheduled”)? The slanted ones are called "smart quotes" which (ironically enough) are not recognized as valid characters in a Smartsheet formula. You will need to retype them here in the Community, directly in your sheet, or in a text editor such as Notepad (not Word).

Paul Newcome

1 ·

Re: Editing Start & End Date w/dependencies enabled

@Paul Reeves Only work around I can think of is that there is a Smartsheet add-on sold by one of my partner firms that can be used to change those columns via a formula.

You would then have a column called something like "Start Date Update" and the add-on would take that value and insert it into the actual Start Date cell. You'd have to refresh the view to then see the new date.