How can I use this highlighted formula. Appreciate quick response
To get the duration you can either use
=[End Date]@row - [Start Date]@row
to get the total number of days,
or you can use
=NETWORKDAYS([Start Date]@row, [End Date]@row)
to get the number of working days.
Are you wanting to edit the formula, or use the output in another formula, or something else?
I am trying to use date formula, I have start date , end date. Want to reflect the gap between two in Duration column
Hi @Yakshita Srivastava
I hope you're well and safe!
If you right-click on a cell you can select something like Edit Column Formula to see the formula.
Did 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 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
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.
@Yakshita Srivastava You said:
"... I am trying to use date formula, I have start date , end date. Want to reflect the gap between two in Duration column ..."
You know that SmartSheet does that for you, right? If you activate a Gantt chart and dependencies, a column called Duration will be used for that purpose. No programming necessary on your part.
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.