-
Dynamic View & Alerts and Actions
I have set up Alerts and Actions in my source sheet, but I have not shared the source sheet with process partners - instead, they have a Dynamic View I'd like them to look at instead. Can Rules and Alerts apply to people who are not shared with the source data? I keep receiving emails about Invalid Recipients and I'm not…
-
Update email address for contacts does not update shared sheets automatically
Hello all, I have been in the process to update email address for some of my contacts due to the change of domains. However in doing this I realized that all my sheets shared with those specific contacts are not updated with the new information. Let's say that I have already shared or assigned tasks to these contacts. I…
-
Translating Data from One Sheet to Another
I am looking for any method that could help me obtain the desired results. I have a tracking sheet titled “PM Sales Tracking” and within the tracking sheet there is a column that is called “Design Request” I have edited the column properties(design request) to a “dropdown list” with values of “yes and no” depending on the…
-
New UI 12-14-2018
This UI is terrible, I don't even want to waste my time explaining why at this point, it is OBVIOUS. At this time I am contemplating updating all training materials, SOP's and videos or just throwing in the towel and searching for a replacement. I simply do not have the time to re-learn, re-document, re-train every time…
-
Redirect smartsheet links to the published link.
Hi there, Hopefully you guys can help me with this, as it would be something that would really help me out with the way my company uses smartsheet. I have a template workspace I've put together that contains portals / dashboards with links to other portals / dashboards, that are also within the workspace. The way copying a…
-
Scheduled Reports Not Generating
I have set up several recurring scheduled reports to be run this week, and NONE of them have run. I am using the "Send as Attachment", "PDF", "Schedule to send later or on a recurring basis", I set it up, then hit "Send", and the recurring event appears in the "Sent to" field with the circular arrow icon to its left, but…
-
how to take the new Filter/Share line off?
Hello everybody, Does anybody know how to take this annoying new "Filter/Share" line down? To permanently hide it. Just a waste of space for us ;( Thanks,
-
Average of lease $ amounts in a certain region
I would like to see the average lease amount per region. I am cross sheet referencing. The formula for the average works. But when I add in the second part (countifs) to make sure a PE GL Checkbox has been checked and to specify a region (I do a cell reference) it doesn't seem to work. For instance, in 1 region I do not…
-
Sorting Issues
I'm still looking into this but has anyone had any issues with the sorting feature? We have one sheet that 17 people are constantly working in a day. (All Editors and 2 Admins if that makes any difference) This morning we SORTED several rows and HOURS later someone who had the sheet open, saved their data and INSTANTLY ALL…
-
Sharing Sheets to Multiple Workspaces
I was wondering if I could have a sheet be located in multiple workspaces simultaneously. For example If I wanted to have individual workspaces for each project I am working on, but also have separate workspaces that would allow me to see overviews for ALL projects, all pulling from the same sheets.
