Could a function be added to update requests that allows them to automatically clear from the sheet after X amount of time if left incomplete? This amount of time would be set by the sheet owner/admin, such as 12 hours. 24 hours, etc. I ask because we have many users that fill out a form in the morning and receive an…
Update Request changes certain cells in a row, while Forms always add new rows to a sheet. Yet we need the customization options for Update Resuest compared to the Form: making fields required, help text, logic, etc. Hope it's underway soon!
Reports with multiple source data such as Project Manager, Size of Project, and # of Projects per PM- Should be able to translate nicely into a stacked graph. Have yet to find a way to do this without being suggested that we need to create a metrics sheet for each project to then roll into a portfolio metrics sheet. If the…
Currently in Sheet Summary, there is no option for a Multi-Select Drop down field. The request is to incorporate multi select to the drop down field option within Sheet Summary.
Would love to be able to acknowledge a comment/callout within the conversation feature without that action over-riding what appears on the Latest Comment column. i.e i want to acknowledge that i am being tasked with something via the conversation feature by entering a "thumbs up" or "eyes" emoji, without having to override…
For reports sourcing from Sheet Summary Data, you would like to be able to: right-click the Sheet Name link and "open in a new window" You could do this only if the the report is Row-Report sourced. Would like the same functionality for a Summary Sheet Report.
We are currently only able to build reports sourcing from EITHER row data or Sheet Summary data. The request here is to have an option to source from both.
This simple function would enable (or simplify) formulas. Autonumbering is the current alternative but requires a column and is clunky. ROW() is helpful to grab cross-sheet data via INDEX when there are multiple sheets with the same row structure but different access permissions.
My team depends on a series of "working" sheets (target sheets) that have a set of predetermined columns that all populate data from a central "data" sheet (source sheet). The data sheet stays static, but the working sheets are frequently added. The ability to duplicate a datamesh and simply change the target sheet would…
Hi The format of the request is basic and doesn't allow any areas of importance to be highlighted. having the ability to add a single colour and highlight / bold / italics / underline would enhance the request. In this example, not being able to bold the two of the words and change the colour means they can get missed.…
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
We are working on a client project. We have 15-20 summary fields and we want to create 5-6 more. The problem is if we add exact names of 5-6 fields, it will take hours to finish it. What we want is to name those fields as 1,2,3,4,5,6 and save it quickly. After this activity, we can. create a sheet summary report and change…
I include fiscal year on most of my sheets. Our fiscal year starts July 1, so I write a formula such as FY = if(Month(date)<7, Year(date), Year(date)+1). Would it be possible to create a FY formula in Smartsheet that returns the FY when provided a date and the FY start? FY(date,FYstart) as FY( mm/dd/yyyy, fymm/fydd )? Or,…
It would be great to have an AI tool that would create a visual map showing how sheets, reports, dashboards, etc and interact in a workspace? This would help with debugging, documentation and training.