Update form functionality - entry cannot be changed

Bruno Schuler

I have an issue using automation rules to have SmartSheet fields updated via forms being send to task owners.

The functionality as such work fine.

However, I have multiple date fields included in the form but the 'Planned End' date seems to be read-only in this form whereas the other ones can be updated. I can't detect any differences in the column settings.

Anybody has an idea?

Andrée Starå

Hi @Bruno Schuler

I hope you're well and safe!

Are you using the Dependencies feature? Is the column selected in the Project Settings?

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Bruno Schuler

Thanks Andrée for jumping on it so quickly.

The column is selected for the form it just is not editable as you can see in the picture

Andrée Starå

@Bruno Schuler

Happy to help!

Is the column locked?

Bruno Schuler

It's open for editing in smart sheet as such and I don't see any column properties settings

Bruno Schuler

It is definitively not locked

Bruno Schuler

Andrée Starå

@Bruno Schuler

I'd be happy to take a quick look.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Genevieve P.

Hi @Bruno Schuler

I agree that it would be helpful to know more about your sheet - could you share a screen capture of the Project Settings window open?

Another reason that a field may be uneditable in an Update Request is if the cell contains a formula. Are you using formulas to populate this column?

Here's more information on Update Requests and fields that appear as read-only: Request fields that appear as read only

Cheers,

Genevieve

Bruno Schuler

Thanks Genevieve,

The article you had provided the link provided the answer:

For my 'Planned End' calculation is activated so I have to include the 'Duration' in my update form.

Thanks to all for the quick response. Much appreciated!

Andrée Starå

@Bruno Schuler

Excellent!

You're more than welcome!

Glad you got it working!