Linking the same date from one cell to a second cell on same sheet
Hi Gang,
I am having a hard time trying to use the date entered in one cell to another cell in the same row from the same sheet. The column I want as the target is RECEIPT DATE and the column for the duplicate date is START DATE. I have tried =[RECEIPT DATE]@Row but it didn't return anything at all.
Thanks for the support,
Melanie
Best Answer
-
I hope you're well and safe!
Unfortunately, it's not possible at the moment to use formulas in the project date fields when using dependencies, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
I hope that helps!
Be safe and have a fantastic week!
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 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.
Answers
-
"@row" is case sensitive. try using a lower case "r".
=[RECEIPT DATE]@row
-
Hello @Paul Newcome . Please see below. That didn't work :-(
-
I hope you're well and safe!
Unfortunately, it's not possible at the moment to use formulas in the project date fields when using dependencies, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
I hope that helps!
Be safe and have a fantastic week!
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 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.
-
Yes. That was going to be my next guess was that you have dependencies turned on and that one of the columns referenced in those setting was the column in question.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!