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've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
