I am needing to update the date to be 2024 in all of these formulas (attachment) and so far I have just been going one by one (January through May) - but figured there has to be an easier way???
Year entrey is fine on smaller scale or if you dont antipate change.I would instead reference a different cell for that potion that has 2023 in it. If you then get to 2024 and change the year in the formula, If the reference is looking at that one 2023 cell, then you change it to 2024 in the one cell and it changes in all of the formulas.
I hope you're well and safe!
Would any of those options work/help?
Would that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
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.
@Andrée Starå - do you have instructions on how to do that?
For this I typically either use a helper row with the drivers needed for a sheet or a second drivers sheet and use cell linking to the other sheet.
I have provided a dynamic view for my users to see content on-screen. However, I've been asked to provide a print option as well. Normally, I would export a report to PDF for 'clean' printing [that is, preserves layout and colours with pretty explanatory note in header]. However, I don't want my users to have access to the…
I was able to create tasks, define predecessors, and see the critical path associated with my project. Is there a way to see the duration of the critical path? In MS Project, I am able to see that my critical path is 113 days, for example. I can't find where I can the details of my critical path, past the tasks that fall…
Hi, Does anyone know if there is a way to send an alert if the value in a cell changes by more than a certain percentage? So, if I have 100 in a cell (text/number) and the value changes by over 5%, I'd like to be able to send an alert. Thanks, Vince
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.