-
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?
-
Published Link
Does the link ever expire?
-
Manage Azure AD users in Smartsheet
Hi, Currently we have a Business Plan Suite, is there a way to manage our Azure AD users in Smartsheet? For example, We have our personal info filled in in Azure AD, how can I import this into Smartsheet? Thanks in advance.
-
Creating Report without Sharing Sheet - I need help!
I am trying to find a solution...I have tasks related to confidential legal matters that are in a smartsheet. As I am breaking those matters down into tasks within the smartsheet there are some tasks that are not confidential and I need my administrative assistant to complete them without being privy to the broader issue…