-
Report Question
Hi All, I am running a report across several sheets within a workspace. For all of my reports, the formulas are showing up correctly for three columns (allocations, total expended, remaining balance) except for one sheet. I cannot figure out where the problem is, as the sheet, columns, formulas, etc. match in all the…
-
"Publish User" modified Dashboard publish setting
When I view the activity log for my dashboard which has be published read only I see that the "publish user" has disabled publishing. I didn't think this was possible. Does anyone know how that would happen? Terry
-
Connect email notification with smartsheet for specific users
Hello, i was looking to create a new project using smartsheet to receive alerts from specific email addresses and to log the activities into smartsheet, those notifications will be received by specific users (their email addresses). how i can start implementing that and is it doable or not? Thanks!
-
Email already exists
hi I'm trying to add a new user, it says that the email is already attached to my account but I can't find it in the users' list. Any idea ?
-
Publish sheet in multiple views?
I'd like to show a sheet in the dashboard in both: 1. Grid view 2. Calendar view WHen I publish the link to put on the dashboard, it only one or the other. Please tell me there's a way to publish in multiple formats!
-
Notifications, Report or Dashboard
i am new to smartsheet and using it to keep track of inventory across multiple locations which have different contacts by location. What is the best method to send a scheduled listing of assigned assets to each contact owner. Would like them to only see their assets and be able to change the location if they no longer have…
-
Preventing One Collaborator from Seeing Sheet which is under collaboration with a different colabora
I run multiple projects (1 sheet for each project). I have external collaborators on the projects. I do not want that person working on one project is able to see other project sheet. Is it possible or under home, all the sheets will be shown to all the external collaborators?
-
Coountifs with date
Hello, i have a excel sheet that has the formula of =COUNTIFS(Alerts!A1:A693,">="&A11,Alerts!A1:A693,"<="&B11,Alerts!C1:C693,R6) I am trying to do the same formula in smartsheets. This is what I have: =COUNTIFS({Alerts Range 1}, >[Column13]4, {Alerts Range 1}, <[Column14]4, {Alerts Range 2}, [Column11]4) What I want to do…
-
Edit Interaction - When this widget is clicked on
Hello, I see that I can go back to the spreadsheet where the original data is when I click on any "part" of the chart (pie on screenshot). However, I'd like to click on a specific piece of the pie "complete, in progress, on hold, discarded" and be sent to just the filtered rule I have set up for each state of the items, so…
-
Sheet Summary Formula Commands
Hi, I am trying to write a formula that counts all the lines with traffic symbols with colors (red, blue, green and yellow), Tried using COUNTIF(OR but didn't work. Id also like to sort this out by color and checkbox for my dashboard. If this is possible?
