Hello, attached is a screenshot. I am interested in having "time sheets" as a view that is linkable to a project. I have made this work using lookup fields, but this seems to only display the first 4 columns from "Time Sheets". I tried creating a ...
Hello, I am trying to use a lookup field from another sheet. It seems that I can only search by the primary field, not by the field I have selected as the source. For example:Sheet 1 - Primary field: Job #Job #: 1234Job Name: Sheet 2Lookup field in...
Hello, wondering if someone could help me correct the formula in the photo. I am hoping for this to happen:If OLD JOB# is blank, display current 2 digit year (CREATED DATE) & "-" & 4000 + ID#. If OLD JOB# is NOT blank, display OLD JOB#For example, l...
For example, I want to see time from a time-sheets table on the JOB BOARD. I also would prefer to see these grouped by employee with a total number of hours for each employee related to this job if this makes sense.
The first part, I prefer not to have the total column on the left. The second part might make more sense. I could just have a reference sheet only. Basically, i am looking to put in employee time related to a lookup project and on project, see to...
