Best Of
Re: Having issues with Year formulas
Does this work?
=IF(YEAR([Date Completed]@row) - YEAR(Age@row) - IF(MONTH([Date Completed]@row) < MONTH(Age@row), 1, 0) > 0, (YEAR([Date Completed]@row) - YEAR(Age@row) - IF(MONTH([Date Completed]@row) < MONTH(Age@row), 1, 0)) + " Y ") + (MONTH([Date Completed]@row) - MONTH([Date Completed]@row) + IF(MONTH([Date Completed]@row) < MONTH(Age@row), 12, 0)) + " M"
Paul Newcome
Re: Row number fuction
I strongly support this enhancement. Also wanted to put the workaround out there for anyone looking for it.
Using the auto number column you can achieve this.
lets say the auto number column is named AutoNumber, and the row number column is named Row
In your helper column you would put =MATCH(AutoNumber@row, AutoNumber:AutoNumber, 0), and make it a column formula.
This would give you the row number at all times after you save.
Samuel Mueller
Re: Is there a way to add a thin vertical line to a dahsboard?
May not be much help, but I did create a title box and added a "|" to it. It still takes up 6 spaces but it'll work for me for now.
Jessica Krueger
Re: Happy 10th Anniversary Community + Giveaway!
In one sentence I would explain Smartsheet to a newbie as:
Marrying a database and spreadsheet to create a one stop data source for better time management and productivity!
Roxsanne
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is a project management platform that helps teams plan, track, and manage projects that functions like a spreadsheet.
Mike.Brown
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is a collaborative, intuitive, and user-friendly tool you can use create customized spreadsheets, forms, reports, dynamic dashboards, data connections and more!
Janae G.
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is a collaborative tool which allows you to centralize information and streamline work processes
for all necessary team members to access simultaneously.
LeiLeni Parks
Re: Happy 10th Anniversary Community + Giveaway!
Redefine the way you plan, manage and execute your projects with a swiss-knife of a solution - Smartsheet!
subirp
Re: Upcoming Tableau WDC 3.0: Timeline for Smartsheet Connector Update?
While we haven't yet switched to WDC 3.0, we're actively monitoring the situation. WDC 2.0 is deprecated, but not yet retired, and we're closely following any announcements from Tableau.
Our current implementation using WDC 2.0 continues to function as expected.
Chris Auty