Best Of
New Membership versus License Model
I've been reading the different posts about the changes associated with the membership model and its impact to "free" users. Is there a single place of information that will clarify what a "free" user can and not do in this new model? For example, would using a Workapp, with dashboards, dynamic view, and so on be available to a "free" user in my business domain? Will it be possible to require a "free" user within my organization to sign in to a form and capture them as the row creator? I quick reference for all things similar and different with this changes would be immensely helpful. Thanks, Sara
swfascetti
Linking Attachments from other Sheets
I have a project Functional Requirements Document that has numerous rows that reference various documents. I have created a document library on a separate sheet and attached documents to the specific rows they reference on the document library sheet to keep the number of attachments uploaded to a single attachment for version history and single source of documentation. Is there a way to reference this single attachment on the document library into multiple rows on the functional requirements sheet? Or will I have to upload 15 copies of a single document to each of the rows on the functional requirements sheet and reupload all 15 copies every time this one document is updated?
Joe Calderazzo
Re: Copy value from one cell of the same row to another
hi so copying in the same sheet without formulas would be impossible - and if you use formulas it will not do it dynamically but statically.
kowal
Re: Include Hyperlink in Automation Email
I am also exploring this. I want to put hyperlinks in the automated email to point people to resources and cannot figure it out. Any help would be great. Can you pull a summary field into an automated email maybe and I put the hyperlink there?
kevin.mecozzi
Re: Primary Columns in Grouped Reports: change label locations and move column
I would like the ability to display the Grouped By text above a column other than the Primary Column. I usually hide the Primary column in reports.
DLove
Re: Request for Rollback - create sheets in Sheets folder
I would like to also share my concerns. Like many others, getting Smartsheet adopted into our workflows took a lot of work. Having this change without any notice of it coming or how it was intended to work has forced my team to be bombarded with questions as to how to function. We are not able to handle these questions and it is causing our management lose confidence in the platform. Unfortunately for us, this change has came at a time that we are restructuring data and streamlining our smartsheet information. As I am in talks with others also responsible for classifying data, I do not have a solution to stand behind because I do not understand how this "update" is supposed to function.
I am assuming that this new structure, and it's migration, are actually well thought out and intended to have a roll-out. If there is a resource out there explaining how we are intended to use the new format to mirror our existing structures, please share it. If there is not a way to allow users to categorize the individual sheets shared with them, and have to rely on a mountain of workspaces based on others naming conventions, please roll it back.
Todd Remter
Re: New USM Alternative
I would suggest that there be an activity based option, where if the user exceeds a number of edits only then will they be charged anything for collaboration as a Member. We literally have some users who edit 1 to 3 times in a single month, it is not justifiable to charge them a license. This USM creates additional overhead for the solution, I'm concerned that although the intention was to make Smartsheet more money, in the long run this will hurt them as a organizations scrutinize how their users are actually using it, thereby reducing the number of needed licenses.
Matt Kirby
Dynamic View Button
It would be nice to have the option of sending a custom email for Dynamic Views, that contains a clickable button to their dynamic view instead of them having to click or copy a link into their browser.
We share dynamic views via automated emails to stakeholders all the time. Currently the dynamic view links exhibit inconsistent behavior when it comes to hyperlinks.
Sree G
Re: Formula for date range after two different dates
Hi @mreynolds66
So I have my date format set up for UK format DD/MM/YY but the formula that I would use is
=IFERROR(IF([Rehire_Date]@row <> "", DATE((YEAR([Rehire_Date]@row) + 3), MONTH([Rehire_Date]@row), DAY([Rehire_Date]@row)), DATE((YEAR([Hire_Date]@row) + 3), MONTH([Hire_Date]@row), DAY([Hire_Date]@row))), "")
Basically saying if the [Rehire_Date] column is anything other than a blank cell the date will equal DATE( Year, Month, Date) using the [Rehire_Date] column as your date starting point, and then else DATE(Year, Month, Date) again but this time using the [Hire_Date] as your date starting point.
The only reason the IFFERROR( ,"") is in there is just incase you have row entries without any of these dates in it. If you are always going to have those rows then you can change the formula to
=IF([Rehire_Date]@row <> "", DATE((YEAR([Rehire_Date]@row) + 3), MONTH([Rehire_Date]@row), DAY([Rehire_Date]@row)), DATE((YEAR([Hire_Date]@row) + 3), MONTH([Hire_Date]@row), DAY([Hire_Date]@row)))
Please double check if the date format changes the DATE(Year, Month, Date) function format
Gillian C
Ability to update the source item (sheet/report) in Smartsheet Calendar App
To ensure the published link isn't broken.
Jacob Schwanz