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 need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…
I am currently in business trial version, but i was told it is supposed to allow for full functionality, however when I click Ctr+F my search menu is only a search bar that allows me to only find the string, and it doesn't allow for replacing. Is it me or the F&R functionality rather limited?
