-
Auto delete unwanted rows
Hi All, is there a way to auto delete older records from a sheet without manual effort. I know we can use copy or move rows depending on dates but still it moved to other sheet. I need rows to permanently disappear if its outdated. Any suggestion much appreciated!!!
-
Dropdown Multi select - ~If formula
Hi all, Been searching about this, but could not find anything so far. Hopefully you can help me. I am just starting to make use of the multi select dropdown list. So i have a spreadsheet with some information in the first few columns. Then comes the multi select dropdownlist column. And then, after that there will be a…
-
If Statement
Hi Team, Can anyone help me how to write this condition In Smartsheet Thanks
-
Can we have chart in sheet like we do in excel
Hi There, Can we have chart in sheet like we do in excel I dont want dashboard I want the chart % to be in sheet column Thanks
-
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…
