-
Enterprise Account login
A while ago, our account was merged into a company enterprise account and all existing sheets I believed transferred over. Account administrators changed etc. If I want to add new users at the same company to Smartsheet can they just click log in using your company account or does someone have to add them as licensed user…
-
Percentage of Total Tasked Complete
Good afternoon everyone! I am trying to format my "% Complete" column to auto populate when changes are made to my "Requirements Total" and "Requirements Complete" (i.e. If I have 10 requirements in my Requirements Total column and I have completed 5 in the requirements complete, which would make my "% Complete" column…
-
Supplier Management - Template
Hi, I cannot find a pre existing template in smartsheet templates Do any smartsheet users have an existing template on their smartsheet account for Supplier/Vendor Performance or Evaluation, preferably with pre defined criteria, and pre formatted score chart and graphs? If so, are you happy to share this template? Thanks
-
RYGG Ball
Hello I have looked through the list of current Formula but cant find any that matches what I am trying to do (see below): If task due date is > 2 days from current date (today) AND Status is NOT STARTED or IN PROGRESS then flag the Green ball If a task due date is < 2 days from current date (today)AND Status is NOT…
-
Editing uploaded files
I am project managing construction jobs and have been given the task of auditing contractors whilst they are on site. I have uploaded the audit forms onto smartsheet as an attachment and I was hoping to edit them while I was on site without downloading them and re-uploading them. The files I am uploading are word…
-
Hiding NULLs in imported dates
I am importing an Excel with some NULL dates. How do I display empty cells instead of NULL? Thanks!
-
Checkbox question
Is there a way to have a checkbox automatically checked if other columns with checkboxes get checked? I have 4 columns with checkboxes and instead of doing value columns for each one I would like to do a summary checkbox and just value one column. If that's not possible, can you set values for more than one column?
-
21 CFR Part 11 compliance and software validation usage in Design Control
I would like to request if there are MED device users to share their experience while working on medical device or pharma projects that are related to new product initiative filings requiring regulatory complaince in closed loop systems integration and security. Have you had to prove part 11 and validation compliance? Your…
-
Am I the only one who does not like the new December 2018 look?
I'm struggling with the new layout and welcome any suggestions. I do not have the dashboard level subscription - just below that, I think. I HATE that I have lost my tabs, and I hate that the menu button ALWAYS takes me back to the RECENTLY VIEWED as opposed to the Home. This new layout just seems like more work to manage…
-
Lookup on a form?
Hi all, Is there a way to have a date/time field on a form look up data in a separate sheet to populate itself? I'm setting up a form for people to select a date and time slot to attend a training session. I thought about having the list in a separate sheet and then only show on the form dropdown the sessions that are…
