We are looking to move our weekly schedule into smartsheet. I was wondering if it were possible to create an intake form for a certain cell. (example) like setting an appointment up (you pick time and date within the schedule)
When a form is submitted it automatically generates a new row on the sheet. You could have the person who is submitting their appointment select a date and time. If you have a date field they could enter any date in that field though, not just what is available on a schedule. An alternative would be to give them a drop down with options like "Next Monday".
Feel free to follow up if this creates additional questions!
Training Delivery Manager / Charter Communications
I hope you're well and safe!
To add to Zachary's excellent advice/answer.
Would that work/help?
I hope that helps!
Have a fantastic week & Happy New Year!
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
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi need help in calculating date based on the cell value in "Grouping" If Cell value in grouping is "A" then add 45 days to the date in "End date" for the date required for populating next cycle count schedule. If Cell value in grouping is "B" then add 30 days to the date in "End date" for the date required for populating…
Just looking for a the formula to count the parent rows from the primary column. I dont need the children in this case.
Hi I have create a formula to calculate the % of margin but when i apply this to the column and there is current data, I get #DIVIDE BY ZERO. my formula is =[Margin $]@row / [Forecast Amount $]@row appreciate any help, thanks
©2024. All Rights Reserved Smartsheet Inc.