I've created a web form that will be heavily utilized. Managers are wanting to conduct a transactional analysis to see how long it takes the worker to complete. I'm looking for a way to capture the current time either when the form was accessed or find a shortcut to copy from the operating system and paste into the first…
I am running a formula to calculate the days between a start date and today(), if the number is less than 25 then it inserts today's date in a cell. That cell is then used to trigger an email to a user for action. If the start date is in the past the calculated days between is a negative. I want the formula to ignore the…
The dashboards that I've created for out Project Management teams contain a report that lists all their active projects with a hyperlink to a project schedule (A different Smartsheet Grid). I've been asked if it is possible for them to open the schedules in a new tab rather than opening it up in the same tab/window,…
Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their implementations. (how well it integrates with SS, potential problems). It doesn't have…
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
Hello! I am needing to set an automation to lock and unlock rows. I have the automation set to lock the row when it is changed from “open” to any other value. I need a time based function that will allow the cell to unlock a certain time period after it is locked by the first automation. Essentially I want to ensure that…
Hi there, Is it possible to add hyperlinks to each option in a multi-select column? For me this is less important in a Sheet than in a Report (or Dashboard), but I presume this would need to be set up in a Sheet for it to flow to a Report or Dashboard. To elaborate, I'd like a Report to have each selected item in a…
Hi there, Is it possible to create a single conditional formatting rule across multiple columns that would only apply to any single cell that matches the rule? For example, I may have a sheet with 10 or more columns for which I'd like a conditional formatting rule that highlights a cell yellow if it has a question mark '?'…
Has Smartsheet created or does anyone have any locally successful templates for helping to plan out Return to Work from a manning perspective? Specifically, our government office is working to have a max capacity (20-30%) of total workforce in the office at any one time, and trying to create a published schedule that…