-
Shared User Removed... By Terminated Employee??
This morning I received a note that a shared user was removed by that same shared user. Clayton Harris was terminated a few weeks ago, but it says he removed himself from this specific sheet. Very alarming! His SSO account was deactivated. It looks like he still had access! In the Activity Log, you can see our head of…
-
Problem email
Hi, I have a problem with my smart, it does not allow me to send mail, it tells me to exceed the maximum amount of email that I can send from my account, to put me in touch, help me see if there is an option to delete emails or something not to increase the amount of mail
-
Enhancement Request
Ability to require text input into a column for approval requests. This would allow the approver to explain the reason for approval or decline. Right now I have an update request based on the approval column, but this requires 2 separate emails. I can use a dropdown with an update request and lock the columns, but that…
-
Close current sheet
I really am not a fan of everything being on the left, but in "trying" to get use to the new layout I have yet to find a way to close the current sheet. I don't want to click on a new sheet just for the current sheet to fall to recent (too many already sit in there now), but I want it to close. Is there a way to close…
-
Conditional Formatting Question?
Hello! I'm very new to smartsheets and have been using them for probably 6 months and I have to create a sheet with conditional formatting where the date drives the coloring of the entire row. I've watched the video's and searched Q&A, however; I feel like my questions are specific to the work I'm doing. Is there any other…
-
Issue setting up report for name off Contact List that has no hits yet
Is there no way to create a report pulling off someone in a column's contact list without actually having an instance of that contact being mentioned in the source sheet? For example, sheet ABC has an "Assigned To" contact list column that includes "Bob". However, Bob does not actually have any tasks assigned to him yet. I…
-
Projects and Dependencies
Is there a way to use a project sheet (enabled with dependencies) with children/parents to where you can control the formula in the parent rows? I'd like to have the parent row average the % complete column children below it rather than sum but when dependencies are enabled, I get an error message.
-
Any limit on the number of report records/odbc connection to excel?
Is there any limit on the number records that can be returned into a report? If you don't mind sharing, what's the largest data set you have in a report? What about a limit on report rows when using the data connector. I'm using the data connector to use the smartsheet report as a data source for a pivot table in excel.…
-
Best practice sharing of links to forms
Hi I am ready to share several Smartsheet forms with my entire organisation (and some external consultants) - currently less than a dozen people - but growing quickly. I am currently the only licenced Smartsheet user. I only want to share the links to the forms, not their respective sheets, to the entire organisation. I am…
-
Use same column type and values on multiple columns
I have 150 columns that will have the exact same column type and values (drop down list with the exact same values). How can I apply those rules to all the columns without having to open each one individually and manually applying the formatting? Thanks