Hi team,
I'm struggling with a request. Not sure if it's a Friday burnout or not. I was asked if we could populate one column of a sheet with a value if it could change the value of a different column.
Ex: when selecting a percentage complete value (0, 25, 50, 75, 90, 100), would like for value selected to populate Phase column (initiate, design, plan, construct, closeout, closed).
Is there a way to set up a formula or automation to do this function?
Thanks in advance!