Update a previous row from a submitted form using workflow.
I have a form with several fields that are completed by a project manager to show the latest update of a project. Once the form is submitted, it goes to an approver, and a workflow moves the entry to a second approved sheet when approval is given. A workflow then sets a new date as the next update field, and additional workflow prompts the PM to complete a new update form when the next update has arrived and the submitted flag is unchecked. The primary key in both forms is the project number.
Question - Is it possible, when a new form is submitted to have it find a previous entry and set a flag as checked so that the next update reminder is turned off?
Best Answer
-
Hi @Craig F
It depends on how this flag/checkbox column is being used. If you're manually checking the box, then you can't also have a formula in the column.
However if you're already using a formula to create the flag or check the box, we can add to this formula to have it look through the sheet and if there's a row with a Later Created Date and the same unique Project Identifier, then flag the current row.
For example, you could use:
=IF([Created Date]@row <> MAX(COLLECT([Created Date]:[Created Date], [Project ID]:[Project ID], [Project ID]@row)), 1
This will check a box if the Created Date in this row is not the latest date in the sheet. Is this along the lines of what you're looking to do? If you have a formula already, could you post that here, along with screen captures (but block out sensitive data).
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @Craig F
It depends on how this flag/checkbox column is being used. If you're manually checking the box, then you can't also have a formula in the column.
However if you're already using a formula to create the flag or check the box, we can add to this formula to have it look through the sheet and if there's a row with a Later Created Date and the same unique Project Identifier, then flag the current row.
For example, you could use:
=IF([Created Date]@row <> MAX(COLLECT([Created Date]:[Created Date], [Project ID]:[Project ID], [Project ID]@row)), 1
This will check a box if the Created Date in this row is not the latest date in the sheet. Is this along the lines of what you're looking to do? If you have a formula already, could you post that here, along with screen captures (but block out sensitive data).
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
That worked great. thank you @Genevieve P.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!