Best Of
Sheet Formula to reference DataTable
DataTables work well for their limited purpose. However, to analyze the data you must create a limited sheets from the data then analyze that data, even if all you want is a Sum Total. I would be great to be able to use formulas that reference this data, such as: Sumif(s), Countif(s), Index/Match and others.
Matt_A
Re: Is there an option to create multiple calendar views to display different column dates?
Thank you Will for the suggestion. I believe I understand where you are going with this but I think my use case is different. I am only looking to show on the calendar a single event on a day. For example, if I have Product A in which I have a column of Ship Date and a Column of Receive Date. I would like a milestone to show up on individual dates instead of a bar connecting the two as many of these will have weeks in-between. I know that Column Master will not be able to have differentiation of Ship Date and Receive Date and would just show Product A but I figured I could address that with some manually formatting but I have not been able to get past the fact that I cannot show two different column milestone dates on the same calendar view.
Shooter71
Calendar View - Display More than One Date
Is there a way to display more than one date column on a single calendar? I have one sheet with multiple date columns and I'd like to see an entry on the calendar view for each of those date columns, but it looks like you can only view one column at a time.
Bethany Garcia
Deactivate the Share function of AI recommended persons
When sharing a workspace or individual asset, there is a new feature where AI recommends people underneath the box "Invite People and Groups". Is it just our company, or is it 99.9% WRONG in your environment, too? We have over 12k users, and the AI recommendations are an annoying distraction, especially because they are wrong.
At the very least, make this a configurable option either per account or per user to toggle this on/off.
If you agree, please add your vote to support. Smartsheet needs to stop whimsically adding little bells and whistles like this which make noise but add no real benefit . Instead, focus on requested features which have been hanging out there for years.
DavidB
Creating unique participant IDs
Hi all,
I am looking for a way to generate unique IDs for individuals filling out forms. We have a number of events for which we have made registration forms. When a person fills out a form, we would like to have the corresponding sheet automatically generate a unique ID for each person that is de-identified. Is there a way to do this?
Additionally, is there a way to keep such a unique ID consistent across multiple forms/sheets if the same person registers for more than one event?
Thanks!
Victoria A.
Re: Showing multiple dates from the same sheet row in a calendar
Hi @Elijah,
In "Project Settings" there is a section for "Date Range Display". This pair of dates is what populates the Gantt and Calendar views. There is not an option for multiple ranges being displayed for the same row.
All the best,
-Ray
Ray Lindstrom
Re: Showing multiple dates from the same sheet row in a calendar
I completely agree with the above desires to have a gantt chart / calendar view with multiple dates on one row! What is needed to have this feature be developed? I've even looked to try to export my data and implement this as a bar chart on excel which is ridiculous when the easiest and cleanest solution is to have Smartsheet to implement this requested need :)
Heather H
Re: Mapping Diagram/ Export Documentation of workflows
Just re-read these comments. A feature to map out automation (+ functions in sheets) would differentiate smartsheet in a world getting very crowded with automation tools!
swfascetti
Re: Mapping Diagram/ Export Documentation of workflows
This would be really nice. Currently I just build a lucid chart , but A I would be much faster!
Tim C