Seems you are trying to manage both columns (Progress and
Status) simultaneously while they are dependable to each other. I believe
you cannot achieve like this although you can manage either of them using
another column.
On Monday, September 27, 2021 at 1:32:55 PM UTC+5:30 mbe...@gmail.com wrote:
> I have two columns for a project plan. One is the Status and the other is
> Progress. I can't get either of these columns to change when either
> 1)Progress reaches 100% or 2)Status reaches "Completed".
>
> If a task is complete, I want it to change the progress to 100%. Also, if
> I change percent to 100%, I want the Status to change to "Completed".
> These are both data validation columns.
>
> TIA,
> Bryan
>
> [image: Screen Shot 2021-09-27 at 2.59.26.png]
>
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to google-spreadsheets-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-spreadsheets-api/ad72e5e7-d10c-4c65-8cd2-6856e2d022b9n%40googlegroups.com.
