-
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…
-
Automation Approval Path with 2 different scenarios
I have created automation for my IT Request form where the User Name [Any Value] is the Trigger. So, depending which "Requester's Title" is chosen from the 2 dropdown options in my form; Supervisor, Manager, I need to set one Request for Approval path if Manager is selected, and a second Request for Approval path if…
-
Dynamic View: Give access for requestors via their email address
Hi Community, we are using Status View at the moment to share the actual status of IT requests (Demands) to the requestors of different department. The access is given to the requestor via their email address they have to maintain while handing in the request and then they have to login in to status view with this email…
-
Notification Issues
Has anyone had any issues with someone not receiving email notifications on certain sheets? Or receiving the email notification and the comment not showing up in the sheet? It looks like a glitch happened to one of our sheets on August 29 and I wanted to see if anyone else had the same issue. It seems to be resolved but…
-
CountIfs for One Date Greater Than Another Within a Given Period
Hi there! I'm trying to get a total of projects projected to start between two dates that actually started after their projected start date. This is the formula that I have so far: =COUNTIFS({Design Document Projected Start Date}, >=DATE(2019, 4, 1), {Design Document Projected Start Date}, <=DATE(2019, 6, 30), {Design…
