I am trying to create a sign in sheet. Day 1 I want the participants to enter their names and check
I recently developed something similar for a client, but it was for a weekly check of the employee's health and more. If you add a so-called helper sheet and a form they use to submit. You'd then use cross-sheet formulas to check the boxes in the main sheet depending on whether they have been submitted or not.
Would that work/help?
✅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:[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.
I hope you're well and safe!
Can you elaborate?
Have you explored the Solution Center?
I hope that helps!
Be safe, and have a fantastic week!
✅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!
So I have a sheet...It has columns for participants to enter their name, and check the date they signed in.
They are using a QR code to access the sheet. I want them to be able to us the QR code to sign in everyday and once they check the new date column it saves and doesn't create a whole new row.
@Andrée Starå Yes thank you so much!
You're more than welcome!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
Hey All! Currently, I have a formula that if it is the Parent row (helper column shows 0) then Index multiple sheets using the SSI column. If it is a children row, use the parent SSI column to Index multiple sheets (pulling the same result). The only issue is if I have a child within a child, then the PARENT(SSI@row) no…
I am trying to write a formula based on two sheets. One sheet, Team Members, that has the following columns: Column 1 - Region Column 2 - Industry Column 3 - Contact The other sheet has many columns, but it has matching columns of the same Column 3 - Region Column 4 - Industry Column 10 - Contact I've tried a bunch of…
©2024. All Rights Reserved Smartsheet Inc.