-
Deactivate User but retain data
When an employee leaves the company, we want to deactivate a User, but retain their data on our sheets (for history reference). If we choose "Remove User Sharing Access", will this simply remove their ability to log into our Smartsheet account? The Status remains "Active" for this employee. Is there a way to change it to…
-
auto update from multiple sheet
Hi, i'm looking for someone who can help out in setting up smartsheet for the company.
-
Help with Google Forms sync
Hi All, I am trying to create a procurement Smartsheet for my company, using Google Forms as a method of collecting data for procurement requests. The reason I am using Google Forms is that it has form logic, which is something the people at Smartsheets have not implemented yet, but are working on from what I am being…
-
IF(And formulas to count late dates
I would like to create a formula that measures the health of a project (Red, yellow, green) with missing dates: Expected Date (June 6, 2019)- I assign that date to the vendor Scheduled Date (this is expected within 5 days of assigned expected date)- this is filled in by vendor Completed Date (this is expected within 5 days…
-
What is the best way to backup my data in Smartsheet?
My company is adding a lot of important and senstive data to our sheets and I am concerned that one of our users might accidently delete data that we need. What would be the best back to backup all of our sheets? Is there feature that will automatically backup our sheets?
-
External Inputs
What types, if any, of external input from other programs is SmartSheet capable of handling/using? IE, is there a way to set up a sheet so that whenever a certain program updates its information your sheet does as well? If so, what types of programs function in this way with SmartSheet? Is it limited in scope or is there a…
-
Sharing Edit Permissions to a Group
I set up a workspace with 4 sheets and will soon include reports, dashboards, etc. I created a group and added my team members to the group. I then shared my workspace with the group, granting them edit/cannot share access. I have instructed them to click on the 'Work Account' button at the log-in screen. My understanding…
-
Set a flag 90 days before due date and after due date
I am trying to flag contracts needing renewals. What am I doing wrong? =IF(OR([Contract end date]1 <= Today1 + 1 - 90, 1, 0))
-
Using multiple working days/resource schedules in the same project
Hello, As a construction PM, one of the functions I use most with SS is the Gantt style programming. I have multiple crews on the same project/in the same sheet, but the issue I have is they each have a different working schedule - for example night shift is Sunday to Thursday night, day shift is Monday to Friday, and some…
-
Smartsheet for Insurance Solutions
Good Afternoon, I wanted to check to see if there are any users in the Property & Casualty Insurance Industry and if so, could you share what you are using it for? I am a new user and still learning all its capabilities. I see that there is a large Healthcare following but not sure about the P&C world.