This is because the wizard only offers 'Reference another sheet' when this is slightly illogical as you are in sheet summary ie to summarise the sheet you are in. You then cant click on the column header to add the range to the formula when using sheet summary without an error. The way to add the range is to scroll down…
We are cleaning up existing sheets and need to see where formulas have been overwritten. It would be great to have a permanent indicator that a cell contains a formula so our users don't overwrite them.
In creating a form the other day, I came across an instance where it would be extremely useful when a user selects an item in the source field via a dropdown selection, it not only shows the needed fields for that specific item, but it also pre-populates the correct information that would also be stored in the target…
Smartsheet is missing the ability to use a wildcard (*) in it's functions. This is a valuable tool and would be incredibly helpful, please add this functionality.
Currently when using the Smartsheet connector for Power BI, is not possible to grab sheet summary information reports, only reports based on sheet row line information. It would be very good to be able to gather information from summary based reports on Power BI.
Hi all, I keep running into an issue where I have core sheets in some workflows/dashboards that users keep deleting and I have to go back an restore it. I would love to have the ability as an Admin to lock a whole sheet to prevent it from being deleted. Ideally, this sheet would still be editable in this use case.
Currently if I could like to reference another sheet in either a cell or in a formula elsewhere, that data must come from a sheet and not a sheet summary. This means I have some data duplicated in a sheet summary for a report, and also in a sheet for use in a reference elsewhere
Smartsheet recently announced the following message via email: We are reaching out to inform you about a recent change that may impact how you de-provision users from your account. De-provisioning options no longer include the ability to delete users from the Admin Center or any other interface such as the API, Directory…
Within Resource Management by Smartsheet, Time Tracking Approval. The submitted time sheet shows Confirmed Time and Scheduled Time. The scheduled time only calculates days that the resource submitted time. Therefore the scheduled time in the approval view is different than the scheduled time under the Schedule tab and that…
Once you have identified your "Favorites" can we get an option to group / organize them into folders please? Thank you
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…
Currently the Arabic language does not work when generating documents which is not ideal for many Arabic based companies and users. I don't see why it isn't added already. As it is taking the format which is displayed on the cell.
It would be useful to be able to create a contact list for a specific sheet. This could then populate in the sheet when you create a contact column instead of needing to list contacts straight into the form to come up as a list. This would be useful when sharing a sheet (like a RACI) with someone else to populate.
The "Test now…" feature currently doesn't reliably reflect what will actually happen when an automation is triggered. I set up an automation using "When a row is changed" as a trigger with a weekly frequency. I wanted to send an update request for only rows where the status had changed to Approved over the last week. When…
