-
Formula for counting how many times a cell has been updated
Is there a formula that you can suggest that will count the number of times a Date has been updated in a specific cell? For example; if I have a date of 4/1/2025 and I update it to 4/21/2025, I would expect to see "2" in a cell titled "Number of times date updated". Delays can happen for various reasons and I would like to…
-
Allowing combining Dashboards into one Dashboard, allowing users to create their own landing page
I have dashboards built for different groups, but some of the people in the two groups work in both, and it would be really great if users were able to combine dashboards for personal use, without having to build three separate dashboards. I guess I'd like a "Dashboard Home", where the user can select from their existing…
-
Moving Comments Between Sheets
I am looking to find a method to copy select columns in a row along with the row comments from one sheet to another. Methods that I have tried and will not work in this scenario: Copying the entire row from Sheet A to Sheet B (This brings over all columns and I am only looking to copy over select columns) Using helper…
-
Merged: Update functions list to include regular expressions
This discussion has been merged.
-
Report data not visible to those with access
Anyone else experiencing this just recently? I have a handful of people not able to see Report data (some or all - depends on the report and it's happening on a ton of them) that they should be able to see and have access to? It's not an access/ sharing permission issue. There is not a current user filter on the Report.…
-
How do I make an embedded form responsive for mobile web?
I have a smartsheet form embedded on a webpage which works great on desktop, but is cut off and doesn't meet accessibilty requirements when viewed on mobile web. Is there a way to make this form responsive for ideal mobile web viewing?
-
Allow for Multiple Lookup Values in DataMesh
-
Auto filling quote number column using automations?
I want my quote number to auto populate a quote number only when a new job row (parent row) is added. We use the quote number NV25-0xxx (ex: NV25-0258, NV25-0259). Multiple clients requesting the same job go in children rows, the children rows get the same number as the parent row so I do not need new quote numbers(I added…
-
Left Function
In the Left function, is there a way to grab just the letters, not another character, such as a dash? I have a column of numbers that include 2-3 letters, a dash, a number, dash, then 1-3 letters. Example: XX-10000-WQA, XXX-10000-WQA. I would like to have a column that just shows the first 2-3 letters, without the dash, if…
-
Multiple Filters In Reports that Collaborators can Choose/Select
I want to be able to develop 1 master log and create reports and forms for employees to use to change or add data. In order to change filters, I believe you need more permissions than an editor. To follow through with my idea, the editors would need to be able to change the filters. What if we had the option to lock or…