-
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)
-
Using HAS with Multi-Selection Dropdown
Hi, I have a multi-selection dropdown with region selections. Next to that column I have the regions. For reporting purposes I need the column for each region to say "Yes" or "No" based on the items selected in the multi-select dropdown. I've created this formula with a variation for each column: =IF(HAS("Central",…