What's the best tool to track simple request that comes to our legal office?
I work for a government agency and I'm in charge of tracking questions that come to our office, like what the question is, the topic, who is handling it, date of request and date completed, how much time it took (e.g., 15 minutes or 2 hours). Then maybe create reports on the type of questions that came in, how many request…
About product (Smartsheet Business plan)
Describe any audit trails that are in place to monitor who is accessing which data? How long the logs are stored? How quickly could Smartsheet restore users data (without alteration) from a back-up if Smartsheet suffered a major data loss? What is Smartsheet RTO and RPO please? Please provide details of any exclusions to…
Data retention polices
How long the logs are stored for Smartsheet Business Plan? How quickly could you restore our data (without alteration) from a back-up if you suffered a major data loss? What is Smartsheet RTO and RPO ?
Email Alerts for Multiple Rows, Individually
Is there a way or setting where I can control how email alerts are sent when multiple rows match the criteria? For a while, even if multiple rows matched the criteria, we would always get individual emails/alerts for each row. (i.e. 6 row match criteria = 6 emails). However, after the recent update, I now only get 1 email…
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
Automated Workflows Limit
Hi Is there any limit to how many "automated workflows" we can create in a single sheet? Asking because one of my projects is expected to have approx 30 automated workflows in it.
Formula to flag a task if not completed before due date
I'm really struggling to get the syntax right on this. I have a column called "% Complete" and a due date column called "Finish." If the % Complete < 100 and the due date is today or already passed, I want to turn on a flag in the "At Risk" column. Ideally I'd actually like to flag it if the due date is tomorrow or already…
Keyboard shortcut to insert a new comment
Hi Does anyone know how to open the New Comment dialog using the keyboard? it's becoming more and more difficult for me to take the mouse EXACTLY at the same point and click, in order to add a comment to the currently active row. We sometimes enter comments to update the status of numerous tasks, and this mouse-based…
Hi, I want to identify rows that have a duplicate entry in a column entitled "Bill Number". How can I create a workaround formula to notify me when there is a duplicate? I believe the best way is to use a checkbox column entitled "Duplicate" and conditional formatting, but I don't know how to write the formula to check the…
Calculate the time between two dates by days, hours and minutes
Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basically, i need to calculate the time between two columns (date received) and (date documents issued) in days, hours and minutes. Cell 'O2'…