How to Link my 2020 Capital Budget to my Capital Budget Form
Hello
My organization has finalized our 2020 Capital Ex Budget. Starting in January 2020, I want to create a Capital Exp Form that provides the options that were approved for the 2020 Cap Ex Budget. For example, the form would be set up as follows:
1. Is the capital expenditure request a 2020 approved capital expenditure.
Dropdown to show Yes or No.
If Yes... then all the capital expenditure items would populate the reminder of the cells from the sheet we have already created.
If No... then the user has to fill out the rest of the form.
This form would create another worksheet separate from the 2020 Capital Ex Budget sheet we have already created.
Thanks
Nillie
Comments
-
Hi Nillie,
Depending on the structure, one way to build a solution would be to have two different links in a form. One link for Yes and another one for No.
Would that work?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives