is this possible? - form fill, populate time, then multiple sheets update based on time
We are trying to automate some contractor time submissions.
Can we:
bi-weekly time sheet - create form that; form pulls drop down contractor name from separate sheet (contractor pay rate). Contractor enters job name from drop down option, enters hours for the week, enters email address and uploads sign off form.
can 2 sheets then take that information to calculate total time for the contractor (he does multiple jobsites during the week) on one sheet. Another sheet takes that info and calculates his pay based on 'contractor pay rate' sheet
Answers
-
Hi @Eric W
I hope you're well and safe!
Yes! You could also use the URL-Query feature to add the information to the form automatically.
When you click on the URL created with the help of the URL query, it will open the Form layout with fields already filled in.
You could use an Automated Alert Workflow and include a link to the form pre-filled by using the URL-Query feature.
More info:
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
Thanks Andree.
-
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!