Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Hello,
I am trying to recreate this formula from Excel into my Smartsheet:
=ROUNDDOWN((DATEDIF([@[Leave Date]],[@[Week Ending]], "d") / 7), 0)
It is supposed to subtract 7 days from the Week Ending date.
How can I make this work in Smartsheet?
try
=FLOOR(NETDAYS([Leave Date]@row, [Week Ending]@row) / 7, 1)
I am creating a form which I want to include a link to a PDF file for anyone completing the form to reference. The PDF is attached to the sheet which the form is associated with. How can I make that PDF accessible to someone completing the form? The closest thing I've found is to create a URL link to the PDF, but that will…
Hello everyone seeking for an answer and help please im having a hard time on approval request automation . My workflow runs smoothly however when the approver open the attachment on the request it automatically downloads and when clicking the approve it says link are already used and auto decline teh approval request…
I am building a dashboard showing data entered into 1 overall workbook. Teams have been given a target amount to hit, so I have also created a second sheet showing a chart/grid that rolls up all the information and compares against targets using formulas calling back to the initial input sheet. If I publish this roll-up…
