-
I Want to Filter Based on a Status and Date
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…
-
Merged: Add Required Field Validation to Automated Update Requests
This discussion has been merged.
-
CountIfs Formula between two criteria
I am trying to do a formula that will pick up the tester and also if it is between a set of range of dates. I did one formula picking up the name, and one doing the set of dates. When I combine the two, I am not able to get it to work. Could someone tell me what I am doing wrong. I am hoping this formula will show the…
-
Can deleted sheets, workspaces and automations from a deactivated user be recovered?
We had a licensed user delete several files before leaving our organization. All of the sheets he owned have been transferred to someone else. However, there was one form we could not retrieve - Themed/Research Session Submission Form. Is there a way to recover that form? Any help is appreciated. Beverly Vance AMATYC…
-
Copy Rows Automation "Something Went Wrong" Error
Hi! I am attempting to redo an automation step that previously worked, but is now malfunctioning. This is a "copy rows to another sheet upon trigger" automation step. I can set up triggers and get to the prompt to search for the destination sheet I would like to copy rows to, and an error instantly returns with "Something…
-
when will the australian region work with apps like zapier
I know this is a problem with EU region as well, but wanted to know when regions other than north america will get support for apps like zapier. Everywhere I have read it is always the app developers saying they are waiting on smartsheets. I have tried cloning the connection app on the websites like zapier and maker and…
-
Smart(Dot) Phrase
A “dot phrase” feature similar to what Epic utilizes would be a valuable addition to Smartsheet. Many teams repeatedly enter the same structured text, notes, or explanations across rows, comments, and forms. Allowing users to type a short trigger such as .phrase that automatically expands into predefined content would…
-
Workflows Keep the Work Flowing Leak-Free
I cannot emphasize enough - Smartsheet is my tool of choice for process management with full integrity and now process leakage. From the Forms that allow you to auto populate the Grids to collect data to analyze and present in a Dashboard, Smartsheet process management is completely self contained. I recently implemented a…
-
Trace Data Moved by Automation
Is there a way to see where data is coming from if it is input or copied into a sheet by an automation? I have a sheet that is receiving to lines of data every night. I am not sure where these two lines of data are coming from. Initially I thought I was just failing to delete everything I didn't need after a sort, but I…
-
Using Smartsheet for SOP / policy acknowledgements?
I’m exploring using Smartsheet as a central place to manage SOPs and internal documents and was curious if anyone is actively using it this way. Specifically, I’m interested in how people are handling things like: Notifying staff when a new SOP or document is posted or updated Requiring staff to acknowledge they’ve read it…