Formulas

Iasonas

Good morning to everyone! I have a Pro plan subscription and i am wondering whether i can use/ edit formulas in cell/column. When i right click, the option to edit formula is visible in the pop up menu, but is not enable.

Should i upgrade the subscrition? i just want to add a simple column "Progress", allowing user to select from specific values 0%, 25%, 50%, 75% , 100% and next a another column "Status" in which i will have the formula, "Completed" when Progress == 100% and Not completed when Progress< 100%

Iasonas

In addition to the above, when a task has Progress "not completed" and is link as start prerequisite with another task, the task will not start and the respective dates/overall plan should be shifted forward, as required/defined from the relationships

Thank you a lot !!!

Andrée Starå

https://community.smartsheet.com/discussion/122305/formulas

Hi,

I hope you're well and safe!

As far as I know, you can use everything formula-wise in all plans.

Can you share some screenshots? (Please delete/replace any confidential/sensitive information before sharing.) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

✅ Did my comment help or answer your question? Please support the Community and me by marking it 
💡 ⬆️ ❤️ or/and as the accepted answer. It will make it easier to find a solution! Thanks!