-
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
-
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…