Best Of
Re: Can automation create a new sheet from a template?
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.
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
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
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
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
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.
Darren Mullen
Re: How Can I use data mesh between two sheets in a push and pull way?
What if you just had all of the individual sub sheets and then rolled them up in a report?
Sticking with your existing structure, it sounds like you have an ideal use case for the premium add-on Dynamic View.
Paul Newcome
Re: How do I create a report where "Assigned to" = "Current User"
Glad it helped!
(I literally asked my co-worker the same question 2 weeks ago so it was fresh on the brain) :)
MoniqueM
How do I create a report where "Assigned to" = "Current User"
I have followed the instructions here:
But, I don't get a "who" option when building a report. How can I dynamically adjust a report to show tasks for the logged in user?
thanks in advance
CycleBagEd
Re: Nested IF Formula
See if this works for you. This ignores the days and year and simply matches the quarter based on the month.
=IFERROR(IF(AND(MONTH([End Date]@row) >= 9, MONTH([End Date]@row) <= 11), "Q1", IF(OR(MONTH([End Date]@row) = 12, MONTH([End Date]@row) <= 2), "Q2", IF(AND(MONTH([End Date]@row) >= 3, MONTH([End Date]@row) <= 5), "Q3", "Q4"))), "")
Carson Penticuff