-
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…
-
Exporting graphs from a dashboard
Is it possible to export a graph from a dashboard? I'd like to be able to use the graph in a PPT presentation but can't find a way to export.
-
Time Lapse Calculation
Hello, I checked the community threads and cannot find a formula that would work. I need help with a formula to calculate the number work days elapsed from the project start date and today. If the task is marked completed under the status column or checked done, stop calculating the days. Thank you for your help.
-
Automating the addition of a task list to a sheet
My department is working on a change management process, the steps of which will be standardized for each change. We're using a web form and alerts to notify the team of a new change request, and managing the workflow with a separate sheet. Is there a way in the workflow sheet to populate the list of tasks without having…
