-
Calculate the time between two dates by days, hours and minutes
Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basically, i need to calculate the time between two columns (date received) and (date documents issued) in days, hours and minutes. Cell 'O2'…
-
How to get back up before making the request?
I want to get a backup on the smartsheet that I am the owner of. What is the way to get that? I didn't request it on the smartsheet earlier. Thank you
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Export a Published Report
Hello - I have published reports to a dashboard that my clients can go and check. However, I've noticed that, if you're looking at a published, read-only report, you can't export it into any useful format, such as excel. Is there something i'm missing? Andy
-
Lead Tracking In Smartsheet
I need to be able to track leads sources in Smartsheet. There is currently no ability to passthrough the URL of the embedded page for UTM parameters. None of the options for fields support scripts to manually pull that URL for example; <script> document.getElementById("demo").innerHTML = "The full URL of this page is:<br>"…
-
Username + Password authentication is still working after disabling in Admin Console
Hi all, We are using Azure AD to authenticate into Smartsheet. Recently, I disabled the Username + Password authentication option (including Administrators) with the goal of users only being able to use SSO. However, users are still able to use their Smartsheet-specific passwords to log into our instance. Has anyone else…
-
Please add admin ability to force password resets
Forcing the reset of a user's password is critical to the security and efficiency of any user management system. Every other web service I can think of that uses an admin/multi-user structure has such a feature. Here are some examples where a forced password reset would be not only useful but dramatically affect the…
-
Effort Vs Duration
Hi I am new to smartsheet and wondered if you could help. I would like to create a project plan which shows the effort required vs the duration. for example: a task may take 2 days to complete however they can complete this anytime within a 5 week time spell - how would I show this on the plan so that the resource…
-
Gnatt chart Bar formatting - grid missing
H Folks, For some reason I have areas in my smartsheet plan that have grid missing, some are ok. Does anyone have an idea how I can correct this and add the gridelines back please. thanks Mark,
-
Please add a successor column or function
A way to show successors is needed. It's important for critical path scheduling that every task has a predecessor and a successor. After a couple hundred lines it becomes nearly impossible to eyeball everything to make sure that's true. A successor column allows one to simply filter to find the missing successors. Thanks.…
