Discussion List
Allow formulas to function in reports
Currently formulas do not update while in a report. If a value changes, you must refresh the report or window to see the updated formula. This creates a lot of confusion since we use reports to gather updates, which results in me being told "your smartsheet is broken" because the formula columns do not update.
Calculate quarter from date
I have a Date Ordered column and want to automatically populate a Quarter column based on the date ordered. What is the best way to write this formula?
Allow users to export a report from a WorkApp
Allow users to export a report from a WorkApp
Request Approval for MULTIPLE Users in one column/cell to generate a document.
Here's what we would like to accomplish: Assign multiple Users to a single column/cell (Bob, Sam, Ed...) Kickoff an Automation to 'Request an Approval' for all Users in Step # 1 Email request to all Users Approve from Step # 2 Confirmation all Users have approved from Step # 3 Only once all Users have approved from Step #…
How to set up an automation with FROM/to changes
Hello Lovely Smartsheet Community! Hoping you can help :) I am working on a deployment project where there are two different eligible vendors, and any of the 7500 clients may switch vendors at any time. Therefore, there are 4 options in my "Vendor" dropdown column: Vendor A Vendor B Ineligible Vendor No Vendor I am trying…
Help Article updates
Hello Community, We’ve updated the API Limitations article and added an AI page to help you learn about artificial intelligence tools in Smartsheet. To view the full catalog of help articles, visit the Help and Learning Center. Were the articles helpful? Let us know by providing feedback at the end of each article.
Anyone know why I am getting random intermittent errors in DataMesh jobs?
Error message: A JSON text must at least contain two octets! I don't do anything and the problem is gone on the next run. This is happening with multiple unrelated DataMesh configurations. I get an email alert "Scheduler Error for Config 'ConfigName' with the message: Hi, There was an issue with one of your DataMesh…
Multiple References and Criteria INDEX/MATCH
Hello everyone, I am working to connect several sheets to create a master "Tracker" for 600+ projects used across the department. I've been able to get pretty far using INDEX/MATCH/COLLECT functions to match by project numbers (unique ID) and pull in dates and status indicators from other sheets used by specialized teams…
Comments on rows that are copied to a new sheet
I want to set up an automation to copy rows from sheet 1 to sheet 2 when a condition is met. Is it possible to have comments that are added on sheet 2 also populate on sheet 1? Basically I want to see any comments added after the row moves on both sheets. Thanks in advance for any advice to solve for this!
Can a report be directly exported from a WorkApp?
Can a report be directly exported from a WorkApp?