If Formula Help
I'm trying to return a date based on the presence of a checked box. I have project plan where we have multiple similar simultaneous activities going on. The PM will check a box to indicate the start date of the First one so I can run a report to show this date across multiple similar projects in my portfolio. I created a Sheet Summary field and have this formula:
=IF([First Construction]93 = 1, [Start Date]93, "") the value returned is correct 6/26/22.
This looks at the column "First Construction" where the PM will check the box on whatever row is applicable as the First area to start construction. Based on that checkbox, I want to simply retrieve the task Start Date of that row.
How do I convert this to a column formula so that the checkbox could be anywhere on the sheet and return the value in the Start Date for the row that is checked?
I was playing with using @row, but I am doing something wrong as I get #UNPARSEABLE with the below formula. I'm sure it's a simple error. Thanks for your help! Patti
=IF([First Construction]:[First Construction]@row = 1, [Start Date]:[Start Date]@row, "")
Best Answer
-
Try this:
=INDEX([Start Date]:[Start Date], MATCH(true, [First Construction]:[First Construction], 0))
Answers
-
Try this:
=INDEX([Start Date]:[Start Date], MATCH(true, [First Construction]:[First Construction], 0))
-
Thank you, Paul!! This is working perfectly!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!