-
Importing New Project and Having it automatically added to our drop down menu in forms
Good evening We have forms we created where one of our form entries is the name of the project. When we create a new project in smartsheet how can we make it so that the project is automatically included in the form dropdown so that we do not have to manually add the project to the drop down of every form? Thank you
-
HELP! RYB Color Change Based on Dates
Hello everyone, I am currently using this: =IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 >= Completion4, "Green", IF(NOT(ISBLANK(Completion4)), IF([Estimated End]4 < Completion4, "Red")))) Which is working but I try to add this: IF(ISBLANK(Completion3), IF(NOT(ISBLANK(Supervisor4)), "Yellow" And it doesn't work, I'm…
-
Combine two columns into another sheet
Simply trying to combine FirstName and LastName columns into a new sheet. =JOIN({FirstName}1:{LastName}1, "-") This come out #UNPARSEABLE
-
Terminating a Team account
We have a Team account but no longer need to use Smartsheet. I've received a reminder that we will be receiving a renewal invoice in the next couple of weeks. I tried to follow the instructions in the help files to cancel the account via the Plan and Billing Info section of our account page, but there is no option…
-
SmartSheet connectivity via ODBC
G'day We are looking at the possibility to migrate our project meeting minutes from Excel to SmartSheet. The Excel-based minutes have columns that pull data from different sources, being Sage and Dovico via ODBC (extracted data is in another tab within the Excel file), is the same possible in SmartSheet? If so, would…
-
Sort, Second Sort, Third Sort (then by, then by)
Trying to sort, then by, then by. Anybody find a work around, second and third sorts pushing tasks to the very bottom of first sort. When the first sort has exhausted all available data I would like items that meet second sort criteria to start in, not be pushed to the very end first sort.
-
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
