-
Linking within a dashboard
Hello! Is there a way to list items that are on a dashboard at the top of the page and then be able to click on that item and have it link to the section that is lower down on the dashboard and have them be taken directly to that section? Thank you!
-
"Created By" Field Inconsistent
I have a sheet that is populated by two forms. When a row is added from one of the forms, the Created By field is populated with the user's email address that sent the form, but the other form just populates as "web-form". Both of these forms are accessed from a single dashboard, so users are always signed in when…
-
New projects not appearing in Report
This must be a user error on my part but I can't figure it out. I have a folder with ALL active projects. That folder is references in my projects status report. However when I add a NEW project, it doesn't automatically populate the report. I need to go in and manually add the new project (Actually, what I do is recheck…
-
Replace value if overdue
Hello, We have a sheet to track teams and supervisors that we update weekly with new hire employees. Each "seat" is it's own row, and to show team size, empty seats are labeled as "Open Spot." If we have a new hire coming in, we put them with their projected team and projected start. On their start date, the other cells in…
-
10,000ft. - Remove timeline for weekends in Schedule view
Hello! I just started using 10,000ft. for resource planning at my company - Does anyone know how to view the schedule and not see the bars across weekends or vacation days? Also holidays - I entered Labor Day as a holiday this year and the way to see it visually is the horizontal grey bars. That doesn't help us from a high…
-
Adding a checklist to a row
We keep our projects on a row-by-row basis. So, we keep all the information regarding each project in the row. We communicate about each project using the message tab on the row and keep all documents related to each project using the attachments tab in each row. The only thing I would love to have is a 'checklist tab' for…
-
WEEKDAY Formula not working
Hey all - I am trying to use the IF(WEEKDAY formula and it's not working. I'm so confused what I'm doing wrong, as I've used this same formula before with no issue. I'm wondering if it's my syntax, or perhaps my sheet? When using it, the error I get is "INVALID COLUMN FORMULA". Here's the formula: =IF(WEEKDAY([Nomination…
-
Adding a Link to a Form
I would like to be able to add a link to a form so that a responder can evaluate a document and then respond to the materials in the link. Is there currently a way to do that?
-
#INVALID COLUMN
Hello Community; I have a formula to calculate a device's time run based off the start and stopped time. This formula is applied to 10 columns (generator 1, generator 2, etc. ) and it works, however, starting in the column for generator 2 and on, l am getting the #INVALID VALUE error. Any ideas how to fix it? Generator 2…
-
Column dependency on another column
Hi everyone, I want the cells in the next column to not be editable until I have filled an accurate values in the current column. For example: I want that nobody would be able to fill the Practices column before they chose the two values in the Lectures column.