How can I improve/automate my workflow?
I currently have a sheet with Smartsheet Licensed Users in our company, we want to check the last time each user logged in to Smartsheet so that if we think they do not require a license we can remove it from their account.
I currently do this by generating a User List Report in the User Management section of the Admin Center, importing that .csv file back into Smartsheet, copy and pasting those last login dates into the column "Last Login Date" in my sheet.
I then have a column "Date Limit" which is set to the last login date + 60 days using a formula (=[Last Login Date]1 + 60). Finally, a checkbox column "Active?" uses the logic: If today is greater than or equal to the date limit, the user is inactive (=IF(TODAY() >= [Date Limit]1, 0, 1) to determine whether or not the user is active enough to warrant a license.
This is obviously inefficient as to be truly accurate I would have to generate a new User List Report every day and manually go in and change these dates, if necessary.
How can I improve this workflow?
Help Article Resources
Check out the Formula Handbook template!