-
Access in a Smartsheet to their specific clinic only
We have Sheets with Clinic names on them. I only want the people from each clinic to see thier stuff when they clinic their link to access the sheet. The also need the ability to update 3 fields without have editing permissions (If that costs extra money). Two or three people per clinic will have access to their info…
-
Target sheet not found in search when trying to create copy row automation
I am looking for help in identifying why a target sheet cannot be located when setting up an automation to copy a row to it. I am admin on both sheets and able to build this automation on similarly built sheets without issue. Also of note, I have DataMesh and Dynamic Views set between my source and target sheets (not sure…
-
Formula help - How to return which Financial Quarter a project Start Date falls into
Hi, I'm not sure if I should be using an INDEX or IF(AND) formula or some combination of the two. I have a sheet that is a Project Tracker with 1 row per project. It contains a [Start Date] column which we've filled out with the date we intend to kick each project off. It also conaints a [Kick-Off Quarter] column in which…
-
Remove expiration time limit on links
It would be nice to not have time limits or click limits regarding attachments that may be sent out via automations. If a recipient doesn't go in and download the attachment (indicated in green in the image below) within a couple of days of receipt, it says the link is expired and they need a new one. When reaching out to…
-
File Attachment to Multiple Rows in a Sheet
When creating document mapping sheets for Projects, or Functional and Non-Functional Requirements response sheets for RFPs, it would be greatly helpful to be able to attach a single file to Multiple Rows in a Sheet. Now, we can only upload a file to a single row, but if that one file applies to multiple rows, it would have…
-
Notification Issue
Hi team, Was there an issue, or possible maintenance, that would have impacted notifications overnight last night (1/15 to 1/16)? My team saw delays up to 60 minutes on a couple of notifications that are typically sent within minutes, and at least one case where a notification still has not been sent. Notifications are…
-
Enhanced Formula Editing - Mass Changes to Formulas on Sheet
Quite often, I am entering the same formula, with the only differentiation being an identifier for a unit or job role. This becomes tedious and is a very manual process. In Excel, the ability to find and replace eliminates this repetitive manual changing to a few keystrokes. Looking for the same functionality within…
-
Audit Cadence Formulas for Due Dates
Hello I am working through a solution that sends notifications to the quality techs when an audit is due. I have been successful with the formulas that capture an audit cadence of Due Monday every week, due every 30 days or 45 days but there is a scenario that has me stumped. Honestly, I am struggling with even where / how…
-
Change bar colors on Web Content Calendar View on Dashboard
Hello, I thout it was worth a shot to post this again. I reached our last April with the same question and the one response I received did not fully understand what I was trying to do. I have a Web published view of a calendar in a dashboard. All of the tasks bars (upcoming conferences) are orange. The calendar is based on…
-
More Sort Levels
Please add the ability to use more sort levels when sorting sheets and reports. It's pretty easy to run up against the limit of only being able to sort by 3 columns. In my personal experience there are cases I've hit where we would need to use 5 columns to have a sheet or report sorted in the most logical order. I'm sure…