-
IF statement works independently but not when combined together in one statement
I have been trying to combine several IF statements into one statement but with out any luck. The If statements work independently but not once I combine them together. The goal is when a date is enter to one of the 3 columns, it will populate from a drop down in another column. If the "Sent Back-Out of Area" column has a…
-
Skip Columns while uploading Data using Data Uploader
We have installed Data Loader and connected Google Drive for testing purpose. Do we have option to restrict columns to be updated. Example - Source sheet is having 16 columns Target sheet is having 1 to 16 columns should extract data from source sheet and rest 17 to 20 columns are having formulas. I was able to…
-
Using Groups once set up
Our team is new to Smartsheets, just getting our sheets set up and ready to share with a broader group. I've created several groups to be able to quickly share content, however, not all of the groups set up appear to be available when I go to share. Any advice on how to troubleshoot so that groups we've created can be used?
-
Renaming Workspaces
Is there a way for admins on workspaces to be able to rename them, or is it only workspace or sheet owners that can do this? Since the admin has full sharing/editing rights, it would be helpful to have them be able to do everything the owner can do so there isn't a bottleneck with every change having to go through the…
-
Conditional formatting to apply to any single cell containing specific text across multiple columns
Hi there, Is it possible to create a single conditional formatting rule across multiple columns that would only apply to any single cell that matches the rule? For example, I may have a sheet with 10 or more columns for which I'd like a conditional formatting rule that highlights a cell yellow if it has a question mark '?'…
-
Highlight Blank Cells
Greetings, Is there a way to highlight ANY blank cells on used rows or rows where Col A = No? My sheet has more than 50 columns. TIA
-
Sorting Unlocked Rows or banging my head against the keyboard!
i have a a sheet. no columns are locked. I have a "Date Changes Made" column that i wish to sort in date order example every entry from 7/1, 7/2,7/ 3 etc so that I can have all dates of the current month together. My list is a running list so it contains dates from April-July so far. When I have used the Sort rows…
-
SUMIFS to Calculate Values for a Specific Year/Date Range
I am trying to use SUMIFS with multiple criteria, and I am failing horribly. I seem to be having trouble when I try to add the criterion to sum data from a specific year (from a Date field) and/or when I attempt to add data from a date range. I have searched the community questions, and I haven't been successful in finding…
-
Numeric Values from form unexpectedly converting to currency
Hi, I have had a sheet with form I've been using for a few years now. Just in the last month, a couple of the columns have been displaying data incorrectly. I have customer numbers that can contain a prefix of $. These are now converting to currency format. So customer $3131231 is showing up as $3,131,231. I also have…
-
multiple IF OR statement help
Hi Can get one IF OR statement but need help with multiples please... =IF(OR(Name2 = "Alex", Name2 = "Dana",Name2="PAt"), "Jo" OR (Name2="Adi", Name2="Mal",Name2="Mark "), "Angela" OR(Name2="Sophie", Name2="Amy", Name2="Elle",Name2="Dan"), "Mary") THANK YOU!