Update Request Form

Hi,

I am wondering if there is a reason why my update request will not let the user update % Complete. Does anyone have any insight to why it will only allow certain things to be updated?

The way the Request is set up is: "On 03/04/19 at 11am In any row where % Complete is less than 100% and Start Date is in the past Send an update request to Assigned To."

I went into the advanced options at the bottom of the request and adjusted the Column Visibility to display excatlly what I wanted. But I just can't figure out why the request doesn't allow the update of % Complete.

Also, I do not have the column set to LOCKED or FREEZE.

Find more posts tagged with

Forms

Project Management

Comments

Mike Wilday

Is there a formula in the column? Is your percentage updated via a formula? If so, that will block editing in an update request.

brandi.meyer80376

The % Column is manually updated. I think the problem was how I was sharing the sheet, I had the recipient set to" Viewer" so I switched it to "Editor-cannot share". I will see at noon if this has fixed the issue.

Mike Wilday

Yes, that would also cause issues. Let us all know if you figured it out.

brandi.meyer80376

I did get this figured out. It was literally something so simple. I was using the parent task as my test run, and you can't change the % Complete in a parent row. So thank goodness it was an easy fix!

Mike Wilday

Haha. Yes, that makes perfect sense.

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…