-
How can I set a dynamic filter on a report to auto change to today's date?
I have created a report to track upcoming go-lives to display on a dashboard, I currently have a filter that specifies an exact date, but is it possible to have a filter that pulls in data for a date 30 days before todays date or even today's date? For example, a condition that will say Original Go-Live is greater than…
-
Resizing Sight To Eliminate Blank Space
Hello, I'm having an issue with a sight where there is blank space at the bottom of the sight which will not go away. This looks ok when using the sight in smartsheet, but when it's embedded in another application using an iframe, it leaves some space. That means the height of the frame has to be large enough to span the…
-
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…
