-
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!
-
How do you apply the same conditional formating to multiple cells?
In excel I can create a formula in a cell, then create conditional formatting on that cell. For example, I can do a quick formula to compare to values. If the value is <0 apply a format that makes the cell red. I can then cut and paste that cell into any other cell I want in a spreadsheet and it gets the formula and the…
-
Can a read-only account export data
We are losing our account data at the end of this week, and will move to a read only account for 30 days. Does anyone know if we have a read only account if we can still export the Project data to Excel and such like, or once read-only you cannot do anything?