-
Predecessors - Either/Or
Is there a way to make predecessors either/or? For example, I have my task on row 3 tied to tasks on rows 1 and 2. But in my project, both tasks 1 & 2 aren't required, they are an either/or kind of task. So I want my predecessors to be set up that task 3 will start when either task 1 OR 2 have been complete. Is there a way…
-
#NOMATCH Error in VLOOHUP when values are an exact match
I have two sheets: Change Oorders and Change Order Pricing. IN Change Orders, there is a column called Task1 which is a dropdown menu. The values in the drop down were copied and pasted from Change Order Pricing, "Task" column which is the first column. I created this formula: =VLOOKUP([Task1]@row, {Change Order Pricing…
-
Cell linking while in Card View?
I am wondering if it is possible to cell link while in card view? When I try to cell link dates to another sheet it appears I have to go to grid view to make that change. I am submitting a product enhancement request to allow cell-linking while in card view.
-
Vlookup/cell linking
Hi All, I've been having a lot of trouble with a vlookup formula that I have linking a sheet with ALOT of columns--just under 200. There seems to be a limit to the number of columns to 'look at' (which is 85.) This is the last formula that I have which works. =VLOOKUP(TODAY(), {1. DOR (Pull-out) Range 1}, 85, false) I…
-
Dependency Workaround: Linked End Date, Not Duration
I'm linking to someone's Start Date on a project, using the relevant sheet. However, the End Dates I need to track are at the end of a long set of tasks on another sheet - only once all those tasks are completed will this person's time on the project be done. I'd like to link to the very last task this person will perform…
-
Countifs with multiple variables
I am trying to automate a tally of which SME's have worked an event with which countries. Ultimately, I created a column that lists the countries that participated in the particular event (ideally I would like to keep multiple countries in one cell per event), and hoped to use the "joined" column to reference the SME's…
-
Can a Finish Date be linked from another Finish Date?
Hi community, I need to link a finish date to an another finish date in another sheet, but the option "Link from Cel lin Other Sheet..." is disabled. I have no problem linking the start date. The duration column will be updated with the difference between the finish date and the start date. This is a special sheet where we…
-
Make the rich text editor edit report cells on the dashboard
Greetings everyone, I was wondering if using the rich text widget to edit a cell in your report on the dashboard live is possible. The logic behind it is: The rich text editor is linked to the cell from a report and updates data simultaneously. Thus, I wouldn't need to go back and forth to the report and then to the…
-
Row or Record roll up and multiple forms or sheets
I have been attempting set up a relational database for multiple client use. This database should track records (rows including child rows) as it progresses through different phases. Projects may stop periodically and should be searchable and may be re-started later. I have tried using 3 column relational connection to…
-
Date miss matching
Hi all, Ok so I reside and work for a company based in Bangladesh and we use this format for date ( Date / Month / Year ) so today will be 30/3/2019 I have two base sheet that feeds directly to a master sheet via direct cell linking which is used by the management to keep track of the latest updated. Now the base sheet the…
