-
Volunteer Allocation
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…
-
How do I set an automation without a trigger or is there a workaround to create a trigger
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…
-
How to make multi-select selections be clickable links (in a report or dashboard)
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…
-
Conditional formatting to apply to any single cell containing specific text across multiple columns
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 '?'…
-
Return to Work Templates
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…
-
Use a Filter to hide/show/reorder columns? (Like a SQL "view")
Hi there, Is it possible to do something similar to a SQL "view" with a sheet? I see that I can create named Filters, but these only let me change which Rows appear -- not which Columns (and not in what order). It'd be very useful to have multiple "views" of a data set that could be targeted to different audiences who need…
-
Adding Formulas to Predecessors Column...Or Is there a Workaround?
Hi there, Okay, so here's what I'm trying to do. Our team is using a smartsheet schedule and within that schedule, is a bunch of sub-schedules, that all work together in glorious harmony :) Up until now, I've been able to use the Predecessors column with ease, for e.g. 1FS + 5d, meaning that the project on the 2nd row will…
-
SmartsheetGOV integration for Microsoft Teams?
Hi there, The integration with MS Teams looks awesome! Unfortunately, it doesn't appear to be available for "gov" customers. Is there a roadmap for implementing that integration? Thanks! Jamie
