-
if checkbox
HI, If a checkbox is selected in column "SNAGS" can another column "DATE RECORDED" automatically populate the date in which the checkbox field was selected? Regards Stuart
-
Project tasks in order but not date dependent
I am trying to set up a sheet that uses a gantt chart to track the timeline for a project with multiple steps that must occur in order. My goal is that the tasks must be completed in order and nothing can be done on the task until the previous task is signed off as completed by the owner. Ideally there would be an alert to…
-
Find next / subsequent date in list
Hi, I am stumped. I am trying to figure out how to figure out the second (and third) date for each unique entry in the Provider/Resource column. I am using this formula to find the first date: =IF(Date@row = MIN(COLLECT(Date:Date, [Provider/Resource]:[Provider/Resource], =[Provider/Resource]@row)), Date@row, 0)
-
Give Specific User Editing Access to a Locked Column
I am looking to give a specific user access to editing a locked column. The background: We have a list of projects that are NOT to be started until our finance director approves said project. As the project manger, I am owner of these sheets. To prevent other users from approving projects of their own will, I have locked…
-
Best Practice - Data Integrity - Forms
When your business starts to build lots of sheets (as we have) the issue of data integrity comes into play. That is if you have lots sheets with names, or activities you can now put them into one sheet and reference to them BUT whenever you build a form and want to restrict the user selection to the defaults in the drop…
-
Tag Multiple Contacts to one row?
At my work we have a project in a row and assign it to one employee, but we also need to, for lack of a better word, tag other employees who need to be able to quickly see the progress being made and oversee the project. Ideally it would be great to have card view show each employee with their assignments in one color, and…
-
Counting party size from Symbols
I would like to use the party size symbol in a form for registration, but am not seeing a formula that would count the responses?
-
Formula Text
I am using this formula and everything looks okay but the text that shows up for "Delivered Early" is showing up in the field as 0Delivered Early. I don't know why. =IF([Days Late / Early]3 > 0, "Delivered Late") + IF([Days Late / Early]3 = 0, "Delivered On Time") + IF([Days Late / Early]3 < 0, "Delivered Early")
-
Notifications work for me but don't work for additional emails in cell
Hi, I'm having issues getting notifications to work. I have line items where there are multiple emails in a cell. I have it set up when a date changes, a request for notification goes out to the emails in a designated cell. The emails go to me when I'm the contact but when there are other contacts in the cell, those emails…
-
Will we ever be able to assign a task to multiple resources?
Is there any update on when this feature will be implemented? I cannot believe it is still not possible to assign a task to multiple resources. We are going to need to move to another site soon if this issue is not resolved. It seems crazy that after 12 years, this essential feature still does not exist, while something as…
