-
Automatically Sort Rows in Sheets
As rows get added & cell values change, it would great if we could automatically sort them in the sheets themselves instead of having to set up reports. Adding the ability to do this in a workflow would be a fantastic addition. Right now we have to do it manually.
-
ADVICE ON A USE-CASE: REQUEST FOR PRICING, QUOTE, APPROVAL, PLACE PO, NOTIFY
We need a sheet or maybe Dashboard / Report / Sheets to accomplish this with our customers. It's a current process we do via email, and want to move it to within Smartsheet. Here are the steps, and am seeking advice on the best process: Via a Shared smartsheet (editor-can share, 3rd party outside of our organization), the…
-
Expand and collapse ALL on the mobile app
I really think it would make things better if I could easily expand and collapse all on the mobile app. It's too much to scroll through on a small screen, and also very time consuming to manually collapse each parent. Especially when it needs 2-5 seconds to save after each change. Please add this feature. I' very fond of…
-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
-
Intake form/Sheets to Document Builder - Font issues
Hello! I created an intake form that captures data onto a sheet. One of the automations I built out is to create a PDF. However, upon creating - I am having issues with the font size that is being populated. The fillable pdf itself has conditional formatting on font size. The smartsheets sheet itself has a formatted font…
-
Date calculation formulas are not working properly.
Hi, community. I have a weird problem with my metrics sheet and the dashboard linked to it since it is displaying fault information with a specific formula. I have tried a lot of workarounds, including the update of both source and metrics sheet and a lot of different formulas but I can't still fix it. Formula is as simple…
-
INVALID DATA TYPE Error in single cell of column formula
Hello, I am getting one cell returning the "INVALID DATA TYPE" error in a column formula. I have 159 rows in this sheet, and only one cell has the error, so I am very confused. The formulas is: =COUNTIFS({Site Visits Range 1}, Type@row, {Site Visits Range 3}, [Primary Column]@row, {Site Visits Range 2}, <>"", {Site Visits…
-
Create New Sheet from Report Results
It would be handy to have a mechanism for creating a new sheet from the results of a report. I envision an option in the report menu "Save Results as New Sheet" where you would be prompted to give the new sheet a name and then the report's columns and their contents (as static values) would fill out the new sheet. This…
-
Connect WordPress form to Smartsheet for Record Keeping
Is there a way I can populate a Smartsheet with entries from a WordPress form? We use the Gravity Forms Addon