Sign in to join the conversation:
Hello, I need to create a health status column (RGY) that correlates to the finish date, percentage (0-100), and status (not started, in progress, complete). Please help me out with a formula because this has been so confusing.
We have a project plan with resourcing allocation built in to it (hours and budget) Currently we have a column for Allocated Hours where we are having to manually enter the below formula into the parent rows. I have figured out a work around by having a secondary column that I have hidden to sum the hours from the childā¦
I am trying to create a New Order Entry form. I have a dropdown list that references our customer sheet. If the customer is not listed, you can choose "(NEW CUSTOMER)", which allows more fields to open up to add the new customer info. If the customer is listed, can I have the address autopopulate into the appropriateā¦
Hi, this column is a date column. I need to extract the day (like Thu) from it for each row. Could you please suggest a formula?
