The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
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...