-
Resource Management Panel not showing all of the managed resources involve in the project
I manage to use the resource management panel, and also the specific sheet and resource management project also seem to sync. One issue though, I have quite a lot of people involved in this particular project. However, only 2 people seem to appear on the panel (as shown on the attached image). Can anyone help me with this?
-
STOCK FOLLOW-UP
Hi everyone, To improve our warehouse we are making a stock tracking. It works like this: When someone takes something from the stock they fill in a form and tick 'use something'. If they bring something back they also fill in the form and tick the 'bring back' box. In the column 'Quantity left' the amount of stock is…
-
STOCK FOLLOW UP/ FORMULA/LINKED SHEET
Hi everyone, To improve our warehouse we are making a stock tracking. It works like this: When someone takes something from the stock they fill in a form and tick 'use something'. If they bring something back they also fill in the form and tick the 'bring back' box. In the column 'Quantity left' the amount of stock is…
-
Move Attachments Only sheets to sheets
From reading other posts I don't think this is possible.... is there a way to copy only the attachment from one sheet to another? I do not want to copy rows. Enhancement request for this function please!
-
NEW! COUNTIF not blank....
I want to count how many columns have a date in the "SMD/IME Appointment Date" row and where the "Case Closure Date" cell in that column is blank: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case Closure Date], )) Attempt #2: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case…
-
Help with counting formulas and exclusions
Hi there, I'm trying to create a formula that would count all instances where a certain option is selected from a Multi-select drop-down and then it would subtract any instances if a certain category has been selected in another column. For example: This formula gives me 13 counts: =COUNTIFS([Curatorial…
-
Fiscal Year Calculation
Hello, I am trying to have a column that calculates a fiscal year automatically based on whether the parent Completed Date falls before or after July 1. Something that follows this logic: If the parent "Completed Date" month is less than 7 (July) display "FY 'Parent Year'", otherwise display "FY 'Parent Year + 1'", if…
-
Formula: if checkbox is checked then add or subtract
Hi everyone, I would like to have a sheet that tells me how many goods we have left in our warehouse. The idea is that employees report via a dashboard whether they are taking something out of stock or returning something. If one checks the column "IN" or "OUT" they also have to add the amount. That amount should be…
-
Triggering a Workflow on existing data
Hello, I can't seem to figure out how to trigger a new Workflow on an existing data set. I created a Move Row Workflow that is triggered by a change in my Status column and where there is a date present in another column (two conditions). I am having to change the Status from Completed, save it, then change it back to get…
-
VLOOKUP with IF and IFERROR Formula
I need to figure out the VLOOKUP formula within the Barrier Management Survey Status Sheet to where IF the Services Completed is “Door Program” (within the Shared Services Program Survey sheet), and the Facility Name matches, to then pull in Survey Status “Complete”, otherwise (IFERROR) "N/A". This is the new formula I…
