Sign in to join the conversation:
I want to populate the % Percent field with 100 when the Actual End Date is entered. I tried this formula but I get an error.
=IF([Actual End Date]@row > "0", "100", "0")
Any suggestions?
Hi Dee,
Try this.
=IF(NOT(ISBLANK([Actual End Date]@row)), 1)
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
To add because I can't edit: Have a fantastic week!
Thank you and it works when I turn off % Complete in Project Settings. But then it wont calculate overall project % complete. I am stuck.
Happy to help!
Unfortunately, you can't have both.
You'd have to disable the automatic % Complete feature and add manual formulas instead.
Would that work?
Another option could be a third-party integration like Zapier or the Smartsheet API. Is that an option?
I am getting blocked with edits again as well... -_-
Yes, i get sometimes now as well.
It's back!
HAHAHAHAHAHAHAHAHA!!!!!!!!!!!
I'm trying to create a formula that will output a Product category. Below is the formula and I've provided a screenshot of the columns involved. =IF(AND(Folder1 ="default", [Cost Category]1="Printer : Plex", ISNUMBER(FIND("Color",[Cost Option]1))), "Color Impressions", If(AND(Folder1="default", [Cost Category]1="Printer :…
Hi All, I have a project plan with a column called "Owner" that has a column type of contact list. The contacts are from multiple companies. It's a large project plan. I have created columns that have a column type of checkbox. I want to check the box if the owner is from a certain company (which can be determined by the…
I have an automated workflow set up to run weekly and request an update when the project is in certain statuses. The automation only ran once and now it's not working even though I have it set up to run weekly. I need help troubleshooting why this isn't working.
