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'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.
