-
Trying to Work with the VLOOKUP Function but hitting a wall
I'm attempting to access a separate sheet with some contact details for various clients. On my CLIENT SHEET I have 8 columns: Licensee, Billing Company, Contact, Contact Email, Street, City, State, Zip On my PROJECT SHEET I have various other project details, but one column is also named "licensee". In the Licensee column,…
-
How to make the primary column something different?
Hi. Is there a way to choose a different column in a report as the primary column? I don't want the one Smartsheet chose. Thanks, SB
-
My Sort Option is Greyed Out
Hello, For some reason, I am unable to sort my columns. I am attempting to sort my first column alphabetically. When I right click on the columns (any) the sort option it greyed out. My other column have drop down settings. I appreciate any help!
-
Count how many jobs start in a month
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
Formulas to identify duplicates
My company is assigning decals to vehicles to monitor our guests. Is there a formula to identify if a license plate has already received a decal if I am looking at my sheet? We will have 2000+ license plates and need this to be a quick glance, or automated notification. I know I am asking a lot so any help is appreciated.
-
Error code 5570 when sending e-mail notification
I have a trial account with Smartsheet. I am using smartsheet API with curl to create/update few sheets. The requirement is to email these sheets at EOD to a couple of users. However, receiving error code 5570, 'you have exceeded maximum number of e-mails that your account can send'. The limitations document states that…
-
This new layout is awful, can it be made optional?
Why would you do this? Did you even test this with customers? Why can't I open as a new tab from the "home" page? Why can't I make the "home" page the default on the side bar? Why can't I make the side bar stay open? This functionality is not working for us as an organization. As the administrator for 8 workspaces with a…
-
Possible to create columns within columns?
Is it possible to create columns within columns with a checkbox in each of the sub-columns as below?
-
Tracking form responses
Hello all, We have a situation where we need to collect information from our customers to complete certain tasks for their projects. We would like to enter data in a column or two (i.e. sales order number, product sold), and then have the form send out to the customer to gather the information we need to configure it prior…
-
Auto uncheck at the end of the day.
Is it possible to clear a check column using Automation. We are planning to use this as a Evacuation check list. We are looking to have it cleared daily (Overnight)
