How do I create a formula that will autofill date when checkbox is checked?
Hi @Sheikha Sharma
Please have a look at my post below with a method I developed.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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
I have two Smartsheet's. The First Smartsheet contains all the original data. The Second Smartsheet will contain unique values from one of the columns (the column with a 1 in the IDUn... column). In the Second Smartsheet, I need formulas in the individual column row fields to look up and match the value in the IDUn...…
Hi, I am trying to calculate duration and I have tried every formula I can google leaving me with unparseable or incorrect argument set... the fields I am trying to use in my metric sheet are "Actual Start Date" and then TODAYS date. I currently have several variations of this =IF(TODAY() - [Actual Start Date]@row)) or…
I'm working on a project that distributes free car seats and we collect data from family members for up to 4 children per family depending on their car seat needs. One entry may include 1, 2, 3, and/or 4 children and we ask for specific demographic data per child. Again, all collected in entry so across multiple columns…
©2024. All Rights Reserved Smartsheet Inc.