-
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…
-
Adding Date to Deliverable Name
Hello, I'm trying to add the End Date to the end of the Deliverable Name to appear as below. Milestone to appear like: "Sample Deliverable Name - [30/08/19]" The End Date and Deliverable name are separate columns in the Workstream Plans. I was thinking about using a formula to merge both columns and then hide that column,…
-
use logic formula to copy an entire line to another sheet
Hi everyone!. I´m from Argentina and 1)thanks for helping :) 2)sorry for my english! :( I need to learn how to use a logical formula in SHEET A to copy an entire line to SHEET B, if one of the columns of the line to be copied has a "R" status ("R" from "restriction" that line has) When entire line appears in SHEET B, I…
-
Report based on specific text in a cell
Hello, I have a data sheet used for a call log for project issues. I'd like to be able to run a report that displays all calls for a specific serial number based on which serial number is entered into a cell, a variable search value. Ideally, I would have a dashboard with a web content widget that would be looking at a…
