-
Data Uploader
Hi, I developed a data uploader workflow in order to update a sheet with the information that is exported from another sheet. The way that I understood this tool is: depending on the settings that I will do, the target sheet should be updated with the information from the attachment file in the source sheet so if the…
-
Easily merging multiple sheets into one comprehensive sheet
This may be a very specific problem but I appreciate any help! I am collecting a certain set of data from people and what I would like to do is provide an Excel template for folks and once they return the template, upload their data into Smartsheet. I know that any import creates a brand new sheet. But I'd like all of the…
-
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.…
